Report configuration management
Moderator: crythias
Report configuration management
I am trying to get a report from all the config-items in my configuration-item management. I want to know the customer, who is using it, warranty expiry dates etc. I am working now with iReport and i am trying to generate the report directly from the database. A lot of the information i am looking for is on the xml_storage stable in the database. But when i am trying to report this, a lot of xml_content comes with it, because the labels are in xml. Does anyone know how i can report this information the best way?
Re: Report configuration management
I am trying to do something similar.
I have added an item to the Computer Class Definition to keep track of the Ship date, which is usually 3-4 years prior to the warranty expire date to the day. It uses the same format as the Warranty Expire date.
I've gotten Ship Date to show up in the Stats module when making a report using the ITSMConfigItem Dynamic-Object so that it lets me select a date range (I want to select all computers that were shipped 4 or more years ago). Unfortunately, the ITSMConfigItem Dynamic-Object insists on formatting the report into a matrix like display listing things like the number of old computers in a particular building (ive added a building drop down to the Computer Class Definition as well). I want it to list out the computers in a similar way as tickets can be listed so I can have a comprehensive list of computers that need to be replaced, what building they are in, what model they are, and when they were shipped.
So far, no luck. I was just thinking of trying to make a .php script to run a MySQL query against the database so I could format it myself. You bring up a great point though, that the data in the DB is wrapped in XML tags. With php I might be able to parse the XML and format it that way...but I haven't tried yet.
I have added an item to the Computer Class Definition to keep track of the Ship date, which is usually 3-4 years prior to the warranty expire date to the day. It uses the same format as the Warranty Expire date.
I've gotten Ship Date to show up in the Stats module when making a report using the ITSMConfigItem Dynamic-Object so that it lets me select a date range (I want to select all computers that were shipped 4 or more years ago). Unfortunately, the ITSMConfigItem Dynamic-Object insists on formatting the report into a matrix like display listing things like the number of old computers in a particular building (ive added a building drop down to the Computer Class Definition as well). I want it to list out the computers in a similar way as tickets can be listed so I can have a comprehensive list of computers that need to be replaced, what building they are in, what model they are, and when they were shipped.
So far, no luck. I was just thinking of trying to make a .php script to run a MySQL query against the database so I could format it myself. You bring up a great point though, that the data in the DB is wrapped in XML tags. With php I might be able to parse the XML and format it that way...but I haven't tried yet.
Re: Report configuration management
I've also tried to make a new table called 'labels' and made a relation between the xml tags and the labels in the 'label' tabel. This works, but i have a bug in my query. I've got to fix it, but i think this is a good solution.