Client Management Suite

I'm trying to create an automated task that emails a report every month that includes all assets (resource types: Computer) that are In Stock (AssetStatus: In Stock). I would like the email to show the computer name, location, and serial number.

The closest pre-made report I found is under: Service and Asset Management > Assets > Assets by Type, Status, Department, Cost Center, and Location. I see that you can select the values for all of these parameters, but I would like the report to only have Asset Type and Asset Status already set to Computer and In Stock (respectively).

I've looked at how that report is layed out, but any changes I make tend to make the query unstable. Anyone have a report like this already? I already have the automated email policy figured out and I understand that portion, but I can't get the report I want to run.

Altiris version is 7.1.

You can clone default report ⇒ click edit and see what Query is there.

Or use "vCMDB_Computer" SQL table to retrieve there required columns only for computers, which are "In Stock" state.

As far as I see "In Stock" state has this Guid {1C139F6C-F210-4002-90D0-4DFAF98D5FA4} in vCMDB_Computer SQL table.

For example simple query to show computers which are "In Stock" state now

SELECT DISTINCT [Name], [Domain], [User], [OS Type], [OS Name], [IP Address], [Status]
FROM vCMDBComputer
WHERE Status='{1C139F6C-F210-4002-90D0-4DFAF98D5FA4}'

Thanks!

That simple query really got me close. I see that it is pulling all machines that are "In Stock," which is the main query that I wanted. However, I tried replacing the domain, os type, os name, and ip address with "location" and "serial number" (which are the last bits of information required) but that kills the query. Are those not part of the vCMDB_Computer table?

I think will be better to use this "vAsset" sql table instead of "vCMDBComputer"

There are columns

_ResourceGuid    _ResourceTypeGuid    _AssetStatusGuid    Asset Type    Status    Manufacturer    Model    Serial Number    System Number    Barcode    Last Barcode Scan    Asset Tag

and then you can add aditional request in query to get location for required resource from this link

• http://www.symantec.com/docs/HOWTO84069