Wednesday, November 13

Browsing: SQL Queries

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

By Eswar KonetiJuly 14, 1:17 pm SCCM 2007 1 Min Read291 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,…

SCCM report computers member of which collection

By Eswar KonetiJuly 01, 11:15 am Collections 1 Min Read10,256 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 Read12,046 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 Read901 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 Read429 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,…