Saturday, August 22

Browsing: SCCM

SCCM report computers with Recently installed programs

By Eswar KonetiJuly 14, 8:19 pm1 Min Read

Gives list of computers where Programs installed recently. SELECT CS.Name0, CS.UserName0, ISW.ProductName0, ISW.VersionMajor0, ISW.VersionMinor0, ISW.Publisher0, ISW.RegisteredUser0, ISW.InstallDate0, ISW.InstallSource0 FROM dbo.v_GS_COMPUTER_SYSTEM…

SCCM report find computer name with SMS GUID:

By Eswar KonetiJuly 14, 4:26 pm1 Min Read

Select Sys.Name0, Sys.SMSID0, Sys.Domain0, Sys.SystemRole0 from dbo.v_GS_SYSTEM Sys Where Sys.SMSID0 = @GUID Prompt for GUID: select SMS_Unique_Identifier0 from v_R_System

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

By Eswar KonetiJuly 14, 1:17 pm1 Min Read

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 Read

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