Re: Cleaning HPCA Agent ID that are not being used anymore (Database Maintenance) (232 Views)
Reply
Occasional Visitor
Posts: 1
Registered: ‎06-20-2013
Message 1 of 3 (266 Views)

Cleaning HPCA Agent ID that are not being used anymore (Database Maintenance)

Hi, is there an efficient and fast way of cleaning an HPCA Agent ID (computer name)? We usually are given a list of computer names to be taken out from HPCA's Database and what we usually do is to open the HPCA web console, go to the Operations Tab then click on Database maintenance. Once we're in there we copy and paste each computer names in the HPCA Agend ID search field and hit on the search. Most of the time, search time takes around 4-10 minutes and another 4-10 minutes to delete them. I'm finding a way on how to delete them X at a time  (5, 10, 20 at a time).

 

I know SQL is a great option but let us just say that we are being discouraged from going the SQL route as some team's say that it is very complicated to touch the database in the backend. Just by using the HPCA web console is there a way to delete many machines at a time?

 

 

Highlighted
Trusted Contributor
Posts: 121
Registered: ‎11-02-2006
Message 2 of 3 (232 Views)

Re: Cleaning HPCA Agent ID that are not being used anymore (Database Maintenance)

 I developed a multi device_id delete method and added the functionality to my Doge application. All Evergreen HPCA support customers have access to my Doge utility and the Webulae Reporting Server with over 2000 custom HPCA SQL queries. You can see a demo of the utility by following the link below. There are about 30 different video's of both Doge and Webulae.   

 

http://www.youtube.com/watch?v=RSiTGvn05Vo

 

Occasional Visitor
Posts: 1
Registered: ‎02-18-2015
Message 3 of 3 (11 Views)

Re: Cleaning HPCA Agent ID that are not being used anymore (Database Maintenance)

Dear jlongo,

 

Please advise how can I reach your Doge application/ tools.

 

In addition, I tried to watch the video, but it is private.

 

Thank you

 

Ahmad Salman

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.