We are still using ServiceDesk 4.5 SP20, and are trying to output all of our UI and DB rules without cutting and pasting each of them. I need to know where in the SERVICE or SERVICEREPO schemae I can find the UI and DB rules stored. If you already have the SQL handy, that would be great too.
That was the correct database location, just the data was encrypted/encapsulated and I can't report on it. points awarded. Any idea if that data is able to be translated into something approximating what we see in the rule itself?
report to get the manager of any assignment group that has a rule affecting them, for example. Or, using BusinessObjects, link the Organization to persons to get a list of all members of groups named in a rule, who might be affected by a rule change.
Hi Ben, Put the attached xsl definition into C:\Program Files\Hewlett-Packard\OpenView\service desk 4.5\client\repo\xsl\view
Then in the Rules display right click and select report format "Sorted Rules" then Preview. This will display all the rules in a nice format. "Publish" this into an html file using the Publish button. Then you can open that file and copy/past into Word etc.
Alternatively, look up itsm007071 - it's a utility in SP22, not sure if in SP20, which deserialises all the rules and also checks them. Format not as good as "Sorted Ruled" format but has been useful.