SCCM 2007 – Page 12 – All about Endpoint Management

SCCM report computers Count of unidentified and uncategorized software’s:

By Eswar KonetiJuly 14, 1:17 pm1 Min Read294 Views

SELECT ISC.NormalizedPublisher, ISC.NormalizedName, ISC.NormalizedVersion, ISC.CategoryName, count(*) as ‘count’ FROM dbo.v_GS_Installed_Software_Categorized ISC WHERE ISC.FamilyName In (‘Unidentified’,'Uncategorized’) group by ISC.NormalizedPublisher, ISC.NormalizedName, ISC.NormalizedVersion,…

Membership Rules-Query Vs direct-based

By Eswar KonetiJuly 02, 10:40 am2 Mins Read3,609 Views

Query based versus Direct membership: Direct membership rules should be created when you want to target a very specific user…

SCCM report computers member of which collection

By Eswar KonetiJuly 01, 11:15 am1 Min Read10,276 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 pm1 Min Read12,071 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 pm2 Mins Read906 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 pm1 Min Read433 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,…

Browsing: SCCM 2007