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,…
Browsing: SCCM 2007
Today ,i updated my SCCM SP1 site server to SP2 .I have listed the actions that might be helpful in doing so .It is…
this post is just to make the application deployment easier.when you deploy any application to a collection,you might see faliure,no…
i was doing OS refreshment with SCCM MDT and i have a TS that has all my configurations required.When it…
select CS.name0 as 'PC name', WS.LastHWScan as 'Last HW scan Date' from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_WORKSTATION_STATUS WS on CS.resourceID =…
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…