All advertisements with specific status : This report gives you all percentage count with specific status for all advertisement in…
Browsing: SQL Queries
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…
SMS/SCCM report with Asset Details information: I had a question from my boss to get list of computers that consists…
I has an issue with the distribution or removal packages from retired / orphaned DP where the packages are distributed…