Client Management Suite

Hi All, If you've done this before or have a method of doing it, please could you share this. We have a fairly simple request to produce a report of new installed Software and Hardware once a week. How can i achieve this through Inventory Solution? It seems this is quite an involved process to setup, or am i wrong? Thanks Steve

definately welcome! :-p

Apparently this was in NS 6 but has been removed from NS7. Has anyone customised a version 7 report to allow for this?

You want to know, by computer, what software and hardware has changed?  Or do you want to know for the entire organization which application or device has been seen for the first time (this is our first Kazaa detection, this is our first HP 1320n printer)?

I suppose both would be usefull, however i'd be more than happy to settle for knowing newly installed apps by Computer and Hardware Change by Computer.

I cant understand why this isnt available in NS7 where as it was in NS6...

Have you done something similar to this as well?

The idea was that we would be able to keep track of our Microsoft Office installations (as well as other custom specified sotware) and New Computer purchases without having to purchase the Asset management module and get by with just our Inventory Solution...

Steve

For software, I have an Automation Policy that runs daily and sends a report to me of any software installed over the past day.  It pulls the data from the add remove programs data.  I went into the Automation Policies and created a new policy, and used RAW SQL as the data source.  This is the SQL I have used.

SELECT InvHist_AddRemoveProgram.DisplayName as [Product Name],
InvHist_AddRemoveProgram.DisplayVersion as 'Product Version',
vComputer.Name AS [Computer Name],
vComputer.[IP Address],
vComputer.Domain,
case when InstallFlag = 1 then 'Installed' else 'Uninstalled' end as Activity,
InventoryDate as [Inventory Date]
FROM InvHist_AddRemoveProgram INNER JOIN vComputer ON InvHist_AddRemoveProgram._ResourceGuid = vComputer.Guid
WHERE (InvHist_AddRemoveProgram.DisplayName LIKE '%') and (InstallDate between getdate()-1 and getdate())

It works pretty well.  I am not an SQL person and I have just recenlty pushed Altiris so there might be a better/easier/more complete way of doing this, but it's a start.

Are you using NS7?

Yes I am.  I would like to include the software from the msi cache as well, just to make sure that it is capturing everything, but I've not had the time to messa round with the SQL.