There are cases,where a computer might be added to different collection and it would be difficult to find out…
Browsing: SCCM Reports
This catagory contains list of sccm reports and its relevent information
select Distinct CS.Name0, SER.Displayname0, SER.Started0, SER.StartMode0, SER.State0 from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_SERVICE SER, dbo.v_FullCollectionMembership FCM where CS.ResourceId = SER.ResourceID and CS.ResourceId…
This report gives you all percentage count with specific status for all advertisement in your environment. In order to get…
This report will list the computers where and When the RAM is changed ? select CS.Name0, CS.UserName0, RAM.TotalPhysicalMemory0, RAM.TimeStamp, HRAM.TotalPhysicalMemory0,…