Is there a easy way to pull detailed report on all my systems... it looks like all my reports show one piece of information or another. I need a complete report on computer name, OS, memory, CPU, etc...

Look at the Asset Intelligence report, Summary of computers in a specific collection report.Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund

SELECT dbo.v_r_system_valid.Netbios_Name0 AS [Computer Name], dbo.v_r_system_valid.User_Name0 AS [User Name], dbo.v_R_User.Full_User_Name0 AS [Full User Name], dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 AS Manufacturer, dbo.v_GS_COMPUTER_SYSTEM.Model0 AS Model, dbo.v_GS_SYSTEM_ENCLOSURE.SerialNumber0 AS [Serial Number], dbo.v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 / 1024 AS [Memory in MB], dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [OS Version] FROM dbo.v_R_System_valid join v_R_user on (v_R_user.user_name0 = substring(v_R_System_Valid.user_name0,charindex('\',v_R_System_Valid.user_name0)+1,len(v_R_System_Valid.user_name0))) JOIN dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_r_system_valid.ResourceID = dbo.v_GS_COMPUTER_SYSTEM.ResourceID JOIN dbo.v_GS_SYSTEM_ENCLOSURE ON dbo.v_r_system_valid.ResourceID = dbo.v_GS_SYSTEM_ENCLOSURE.ResourceID JOIN dbo.v_GS_X86_PC_MEMORY ON dbo.v_r_system_valid.ResourceID = dbo.v_GS_X86_PC_MEMORY.ResourceID JOIN dbo.v_GS_OPERATING_SYSTEM ON dbo.v_r_system_valid.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|