Asset Management Suite

 View Only
Back to Library

General Asset Report Filter by Organizational Group 

May 04, 2010 03:15 PM

This morning I had to create a custom report that would allow me to filter the General Asset Report by Organizational Group. Here's how I added the filter.

Clone The General Asset Report:

Edit the cloned report preserving the “canned” General Asset Report. With the Data Source Tab selected add the SQL Code to the Parameterised Query as illustrated below:

Before moving away from this tab also add the highlighted code to the bottom of the Parameterised Query as illustrated:

Under the Query Parameters Tab Add the Scope By Organizational Group Parameter as illustrated below:

Last step is to add the Scope By Organizational Group Parameter to the Report Paramemters:

Save your changes and now you can filter the General Asset Report by Organizational Group:

I hope this may be of use to someone. It sure helped me!
Cheers,
Mike

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Migration User
Aug 06, 2010 01:55 PM

Nice job.  I forwarded to the new product manager.

Sandy

Migration User
Jul 08, 2010 08:05 AM

Thanks Michael_S,
Quick question, Ive added Manufacturer and Model which was easy enough, now im trying to add Primary User but having no luck. Could you perhaps give us a little help?

Many thanks.

Migration User
May 06, 2010 08:59 PM

This seems like a good way to maximize the general asset report and save time.  In my environment, the details were populating individually, so I will share this insight within our group and see if we can generate this report.

Thanks so much!

Migration User
May 05, 2010 12:14 PM

Hi Leisuretech. Here's one more. You can clone and modify the Computers by Serial Number Report to essentially achieve the same result. Under Reports->Discovery and Inventory->Inventory->Cross Platform->Hardware->Serial Number->Computers By Serial Number. The hard work is already done since the canned report includes all the SQL joins. Just make a few additions to the SQL query and then a few modifications to your report parameters and now you have the same results with the filter option. The highlighted additions I made are just additional columns in the dbo.vHWComputerSystem view of the CMDB. You can also reference several additional columns from the v.Computer view like OS, IP, primary User, etc... You can do a lot just with this canned report. I hope this helps!


Mike

Migration User
May 05, 2010 08:21 AM

Okay, that makes sense! We do not have the Asset Managment Solution. I will try to work this into another report. If you have any more reports please post them.

Thanks,

Migration User
May 04, 2010 05:50 PM

The Report is part of the Asset Management Solution. Here's the report I cloned and then "tweaked".


Cheers,
Mike

Migration User
May 04, 2010 04:36 PM

Is your general asset report a custom report? I do not see this report. I do however see an "All Assets" report.

Thanks

Related Entries and Links

No Related Resource entered.