This post is more than 5 years old
25 Posts
0
1015
Data enhancement via HP Asset Manager
My client has all of their equipment and its location (down to the grid) in HP Asset Manager We are considering scheduling a job to extract the location of everything with a serial number, and using that to feed data enhancement. What we need is the way to pull the info from the database and stick it into a CSV file. Has anyone ever done anything like this? I'd love any help or advice you can provide, before someone has to start writing custom C# code. Thanks!
fredde1
120 Posts
0
October 4th, 2016 17:00
Sam:
You should be able to do it through data enrichment and the property tagging filter.
You should be able to use The JDBC accessor which is used to fetch data from a database using a JDBC driver
Take a look at the Property Tagging Filter Administration Guide in the SRM GUI.
Thanks
Tim
fredde1
120 Posts
0
September 27th, 2016 12:00
Hey Samuel:
It is not supported or advised to manipulate the SRM DB.
Alternatively you could create a custom report and export the csv file from that.
Thanks
Tim
fredde1
120 Posts
0
September 27th, 2016 12:00
Samuel:
Although you cannot do it through the DB, you should be able to do it through SOAP.
Take a look at the APG-Web-Service-Tutorial.pdf
On the install the file is located in /opt/APG/Web-Applications/APG-Web-Service/APG-WS/doc/APG-Web-Service-Tutorial.pdf
If you cannot find it, let me know and I can send it to you privately.
Thanks
Tim
.
samwyse
25 Posts
0
October 4th, 2016 06:00
Sorry I apparently wasn't too clear. My plan was not do anything with the SRM DB, but to read from the Asset Mgr DB and create a CSV file for use by SRM's Data Enhancement.