peterdcross

I looked at the link and ran a Profiler test. The record is inconclusive as the connection to run the test report can be seen but not an error on save. This is test domain with everything opened up, one connection account and an NTSERVICE account. I shall pass on custom reports. Life's too short to waste it on Microsoft's dodgy products. Have you ever noticed that their support sites can have a thousand pages of written instructions and not one screen shot! This from a company that provides a GUI interface!

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