Asset Management Suite

Hello, I am trying to customize the report "Computers that have not reported inventory in last N days" , and I have a few questions:

1- I need to be able to sort by different statuses (does the report take into consideration the machines in "retired" status?)

2- I need to be able to retreive more information (columns) than the ones that currently show up in the report.

Any help is much appreciated.

AFAIK the report is only for Active computers, all others should not be reporting.

To add columns you can cut and paste the "Resolved query" from the report into the SQL pane of a New View window (right-clcik on views > new view) in SQL Server management Studio attached to a test or copy of your prod db.

Thanks for your reply. I am wondering if I can get some help with the code to get to what I am looking for. Thanks!

If you put the existing code into the View generator you can pick the info for yourself.

Thanks. I am new to SQL Server management Studio. Does it have to be attached to a copy or a test DB, or can it just be the Production DB? Also, is there a useful tutorial to get me started? Thanks!

You can use the prod db, but as a novice that's risky. I just learnt as I went along, I installed the SQL Server Books online fromMicrosoft downloads to help me with some of the query language (Transact or T-SQL).

But if you start with pasting the existing SQL into a new View you can easily work out how to select extra columns from the tables or views already in the report.