Open-AudIT
https://www.open-audit.org/phpBB3/

[solved] Add asset tag to Device Hardware query
https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6407		 Page 1 of 1
Author:  tlmedia [ Tue Feb 10, 2015 11:00 am ]
Post subject:  [solved] Add asset tag to Device Hardware query
Hello, running Open Audit 1.5.3 on CentOS 6.6.

Is it possible to modify existing queries? I'm trying to add Asset Tag to the hardware report. When I go to Admin, Queries, List Queries, then click the Edit Report button for a query, I get this message:

Edit Report

Page Incomplete
Place holder for an incomplete page.
Author:  Mark [ Tue Feb 10, 2015 11:38 am ]
Post subject:  Re: Editing existing queries
Yep - that page needs some love :-)
If you're interested in sponsoring some development, please (PLEASE) see my sig.

When you say "Asset Tag", do you see this information somewhere else in Open-AudIT and if so, could you attach a screenshot showing where?
There are a couple of fields it could be. If I can identify the correct one I'll cook you up a new Query Definition...
FYI - There is bios_asset_tag in the bios table and man_asset_number in the system table. Just need to make sure I get the correct one :-)
Author:  tlmedia [ Tue Feb 10, 2015 12:27 pm ]
Post subject:  Re: Editing existing queries
Thanks, I'm interested in the one under Purchase Details. Screen shot included.

PM sent about donating. Thank you.

Attachments:
asset.jpg
asset.jpg [ 49.84 KiB | Viewed 4772 times ]
Author:  Mark [ Tue Feb 10, 2015 12:35 pm ]
Post subject:  Re: Editing existing queries
Try the attached.
Insert the XML to menu -> Admin -> Queries -> Import Query.

No PM received yet :-(
Email me direct if you like.

Attachments:
DeviceHardware.xml [3.11 KiB]
Downloaded 301 times
Author:  tlmedia [ Thu Feb 12, 2015 1:59 am ]
Post subject:  Re: [solved] Add asset tag to Device Hardware query
Thanks, I see that new report, and it shows the asset number column. However those fields are all blank, even if I have asset numbers filled in. Again, I'm using the asset number under Purchase Information (see screenshot). Perhaps this SQL is pulling the wrong one? I notice you're using system.man_asset_number

Thanks
Author:  tlmedia [ Mon Feb 16, 2015 3:12 am ]
Post subject:  Re: [solved] Add asset tag to Device Hardware query
Found the problem, it was just a typo. The SQL SELECT was correct, but when you displayed the data you used man_asset_tag instead of man_asset_number.

Works great now. Updated version attached. Thanks

Attachments:
DeviceHardware.xml [3.11 KiB]
Downloaded 310 times
Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/