Altiris, Altiris, Altiris ... Reporting in a nutshell

So, outside of my normal meetings and some random discussion about things going on with my current projects (only a couple of hundred, no big deal), I have been tasked with creating a series of reports to show how our deployments are progressing...

Ideally, I would like to see us be able to develop a report that shows each package that we have, how many users are targeted, how many have been active on the network in the last 30 days and how many have success or failure codes... The percentage of success should be based on the successful installs vs the 30 day log ins (as I don't believe that holding us accountable for PCs not on the network is fair).

This approach will give us a long term deliverable for our Altiris implementation and allow us to quickly see how any particular deployment is progressing.

More details to follow (along with the sql for this once finished).

OK, a little SQL code to show some possibilities here:

SELECT A.[AdvertisementName]
, [Succeeded] = (SELECT COUNT(*) FROM [AeXInv_AeX_SWD_Execution_Summary] AS B WHERE A.[AdvertisementId] = B.[AdvertisementId] AND (B.[Status] = 'Command executed' OR B.[Status] = 'Finishing asynchronously'))
, [Failed] = (SELECT COUNT(*) FROM [AeXInv_AeX_SWD_Execution_Summary] AS C WHERE A.[AdvertisementId] = C.[AdvertisementId] AND C.[Status] != 'Command executed' AND C.[Status] != 'Finishing asynchronously')
, [% Successful] =
(SELECT COUNT(*) FROM [AeXInv_AeX_SWD_Execution_Summary] AS B WHERE A.[AdvertisementId] = B.[AdvertisementId] AND (B.[Status] = 'Command executed' OR B.[Status] = 'Finishing asynchronously'))
* 100
/ ((SELECT COUNT(*) FROM [AeXInv_AeX_SWD_Execution_Summary] AS B WHERE A.[AdvertisementId] = B.[AdvertisementId] AND (B.[Status] = 'Command executed' OR B.[Status] = 'Finishing asynchronously'))
+ (SELECT COUNT(*) FROM [AeXInv_AeX_SWD_Execution_Summary] AS C WHERE A.[AdvertisementId] = C.[AdvertisementId] AND C.[Status] != 'Command executed' AND C.[Status] != 'Finishing asynchronously'))
FROM [AeXInv_AeX_SWD_Execution_Summary] AS A
GROUP BY A.[AdvertisementName], A.[AdvertisementId]
ORDER BY A.[AdvertisementName]