Thursday, December 26

Browsing: SQL Queries

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,…

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,072 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 Read907 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,…