Friday, August 3, 2007

Exporting Business Rules from HP OpenView Service Desk to Excel

Using the HP OpenView Service Desk client open the Administrator Console. Then navigate to the Business Logic node. Expand that portion of the tree to show the Database Rules and UI Rules nodes. Click on which ever set of rules you would like to export. Go to the File menu, change Report Style to Table or better yet a Bordered Table. Then choose Print Preview from the same File menu. Click or highlight some of the text in the preview. Then do a control-A and then control-C to select all text and then copy. Go to MS Excel, open a new worksheet, and paste. You will need to make it pretty, but all the data is there. I recommend setting the column height to something like 12.75 if you like the default height that you usually get from a new Excel spreadsheet.

No comments: