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