Wednesday, July 24

Browsing: SQL Queries

SCCM report computers member of which collection

By Eswar KonetiJuly 01, 11:15 am Collections 1 Min Read10,186 Views

There are cases,where a computer might be added to different collection and it would be difficult to find out…

SCCM Report for computers with service status (started,stopped,disabled)

By Eswar KonetiJune 12, 5:10 pm SCCM 2007 1 Min Read11,966 Views

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…

SCCM report to list All advertisements with specific status

By Eswar KonetiJune 12, 4:51 pm SCCM 2 Mins Read886 Views

This report gives you all percentage count with specific status for all advertisement in your environment. In order to get…

SCCM report to list machines where and When RAM changed?

By Eswar KonetiJune 12, 4:15 pm SCCM 2007 1 Min Read421 Views

This report will list the computers where and When the RAM is changed ? select CS.Name0, CS.UserName0, RAM.TotalPhysicalMemory0, RAM.TimeStamp, HRAM.TotalPhysicalMemory0,…