Both MySQL and SQL Server do a good job of supporting all major protocols for accessing their respective databases. A…
Browsing: SQL Queries
You might have different operating Systems installed on the computers.One fine day your boss might request you to get list…
All advertisements with specific status : This report gives you all percentage count with specific status for all advertisement in…
if you want find out the computers that doesnt have particualr software installed in,you may write query where applications!=adobe which…
SELECT c.Name0, a.DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS a, v_R_System c WHERE a.ResourceID = c.ResourceID AND a.DisplayName0 like ‘%Adobe acrobat%‘ GROUP BY c.Name0,…
In this blog post ,we will talk about how to get list of all applications installed on specific computer or…
Below listed the basic reports to display computers with particular add and remove application installed on computers. Report to list…
SELECT GS.Name0 as 'PC Name', GSS.DisplayName0 as 'Service', GSS.StartMode0 as 'Startup', GSS.State0 as 'State' FROM v_GS_SERVICE GSS, v_GS_COMPUTER_SYSTEM GS Where…