Client Management Suite

Hopefully a simple one, I haven't managed to find this anywhere.

I want to have a report of all computers/assets with a status of 'missing' that I can put in a scheduled email. I've tried to modify several existing reports but haven't had any luck, and a few other reports allow you to get the information but only by selecting a status from the drop down list first, which isn't any use for an automated report.

Could someone help please?

Will this query work?

Thanks, it seems to work if i say WHERE va.Status = 'Active' but not for 'Missing' - is it referenced by something else?

Well crap.  Sorry, it was kind of a guess.  Since we don't track assets with Altiris, I had no way to test it.

If you have truly marked an Asset as "Missing", then this query will work:

Hmm maybe thats it, I've used this:

https://www-secure.symantec.com/connect/forums/report-inactive-machines-and-automatically-change-asset-status-missing

So if something hasnt reported in for 30 days it changes it to missing, hence I want a report so that we can investigate those machines.

If I use the built in report "Assets by Type, Status, Department, Cost Center and Location" and filter with 'Missing' it does report the correct machines.

Any ideas?

That was the report I looked at to determine where they were pulling the status from.