Ok I had a report that worked just fine in CMS 7.1 but now in 7.5 SP1 HF5 we noticed the report works but is missing some information.
Here is where it gets confusing.
1. Report Runs
2. missing client date for a specific computer (not all of them)
3. code runs in SQL Studio
4. if I Edit Altiris report and just try to save I get errors where it says you cannot create, delete so I look through and I have
t0.[CreatedDate] AS 'CMS Created Date'
i delete this line and my computer now has the correct client date listed. and I can save the report. I added the line back and changed the Created to Installed and now I can save the report and it works.
So my question:
What changed where you cannot use Create in ' ' to rename the column?
Is there a better approach now?
Why would Altiris report not take what is inside ' ' and treat it as text?
for anyone that wants to try it... this will work..
SELECT DISTINCT T0.[Name] AS 'HostName', t2.[Client Date], t1.[Chassis] AS 'Catagory',
t2.[Hardware Serial Number], t0.[CreatedDate] AS 'CMS Install Date', T3.[Model] AS 'Product/Model', T3.[Manufacturer] AS 'MFR',
t0.Guid as _itemGuid
FROM [vComputer] T0
LEFT OUTER JOIN [RMV_HW_Hardware] t1 on t0.[Guid] = t1.[Guid]
LEFT OUTER JOIN [Inv_AeX_AC_Identification] t2 on T0.[Guid] = t2.[_ResourceGuid]
LEFT OUTER JOIN [vHWComputerSystem] t3 on t2.[_ResourceGuid] = t3.[_ResourceGuid]
Order by T0.[Name]
This will not
SELECT DISTINCT T0.[Name] AS 'HostName', t2.[Client Date], t1.[Chassis] AS 'Catagory',
t2.[Hardware Serial Number], t0.[CreatedDate] AS 'CMS Created Date', T3.[Model] AS 'Product/Model', T3.[Manufacturer] AS 'MFR',
t0.Guid as _itemGuid
FROM [vComputer] T0
LEFT OUTER JOIN [RMV_HW_Hardware] t1 on t0.[Guid] = t1.[Guid]
LEFT OUTER JOIN [Inv_AeX_AC_Identification] t2 on T0.[Guid] = t2.[_ResourceGuid]
LEFT OUTER JOIN [vHWComputerSystem] t3 on t2.[_ResourceGuid] = t3.[_ResourceGuid]
Order by T0.[Name]