Search the Community

I have been following the advice to create custom forms as deatiled in: www.windows-noob.com/forums/index.php?/topic/1381-computer-model-and-name-report/ Everything works (Fail 1) up to the RUN (Fail 2) then this error occurs (Fail 3) If the report was sucessfully run earlier why would it fail later? More to the point how can I fix it? Note: All the built in reports work correctly O/S 2012 std SCCM 2012 SP1 SQL 2008 R2 SP2 SELECT A.Name0, B.SerialNumber0, A.Manufacturer0, A.Model0, C.Name0 AS 'Processor', D.TotalPhysicalMemory0 AS 'Memory (KBytes)', E.Size0 AS 'Disk Size (MBytes)', F.MACAddress0, F.IPAddress0, G.AD_Site_Name0 AS 'AD Site', A.UserName0 AS 'Last user logged in', H.Caption0 AS 'Operating System', H.CSDVersion0 AS 'Service Pack', G.Creation_Date0 AS 'Creationdate in SMS', I.LastHWScan FROM v_GS_COMPUTER_SYSTEM A, v_GS_PC_BIOS B, v_GS_PROCESSOR C, v_GS_X86_PC_MEMORY D, v_GS_DISK E, v_GS_NETWORK_ADAPTER_CONFIGUR F, v_R_System G, v_GS_OPERATING_SYSTEM H, v_GS_WORKSTATION_STATUS I WHERE A.ResourceID = B.ResourceID AND A.ResourceID = C.ResourceID AND A.ResourceID = D.ResourceID AND A.ResourceID = E.ResourceID AND A.ResourceID = F.ResourceID AND A.ResourceID = G.ResourceID AND A.ResourceID = H.ResourceID AND A.ResourceID = I.ResourceID AND F.IPAddress0 is not NULL AND F.IPAddress0 not like '0.0.0.0' GROUP BY A.Name0, B.SerialNumber0, A.Manufacturer0, A.Model0, C.Name0, D.TotalPhysicalMemory0, E.Size0, F.MACAddress0, F.IPAddress0, G.AD_Site_Name0, A.UserName0, H.Caption0, H.CSDVersion0, G.Creation_Date0, I.LastHWScan