Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Reports - Computers that have not reported inventory in last N days

Created: 20 Mar 2013 | 5 comments

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.

Operating Systems:

Comments 5 CommentsJump to latest comment

andykn101's picture

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.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

richietheprogrammer's picture

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!

andykn101's picture

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

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

richietheprogrammer's picture

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!

andykn101's picture

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.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.