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, ISC.CategoryName order by ISC.NormalizedPublisher, ISC.NormalizedName, ISC.NormalizedVersion, ISC.CategoryName

  There are cases,where a computer might be added to different collection and it would be difficult to find out the computer is member of which collections.Try this report to list all the collection the computer member of. select a.CollectionId, b.Name from dbo.v_R_System r join dbo.v_FullCollectionMembership a on R.ResourceID = a.ResourceID join dbo.v_Collection b on…

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 = FCM.ResourceID and SER.displayname0 like ‘%firewall%’ and (SER.State0 != ‘Running’ or Isnull(SER.State0,”)=”) and FCM.CollectionID = ‘SMS00001′

This report will list the computers where and When the RAM is changed ? select CS.Name0, CS.UserName0, RAM.TotalPhysicalMemory0, RAM.TimeStamp, HRAM.TotalPhysicalMemory0, Max(HRAM.TimeStamp) from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_X86_PC_MEMORY RAM, dbo.v_HS_X86_PC_MEMORY HRAM Where CS.ResourceID = RAM.ResourceID and CS.ResourceID = HRAM.ResourceID and RAM.TotalPhysicalMemory0 != HRAM.TotalPhysicalMemory0 Group by CS.Name0, CS.UserName0, RAM.TotalPhysicalMemory0, RAM.TimeStamp, HRAM.TotalPhysicalMemory0