Create a request in the Admin/Query phrase book
the OQL could look like this (replace Customer with the Organization name you need) : "
SELECT UserRequest WHERE start_date > :date1 AND start_date < :date2 AND org_name = 'Customer'
This is for UserRequest, but you can use a different class depending on your needs, like Incident, Change ...
Also, you can remove the DATE filter if you don't need. (date should be in the aaaa-mm-dd format)
After you've created the Query in the phrase book, you will notice a URL to use for MS-Excel web queries. Try open it in Excel and you are done. All you have to do is customize your excel file.
Hope this helps
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am testing the ITOP program.
I found there is a lot a good things .
But i need to have reporting by contract and for example to have access to a report withe all the ticket submit in a contract ?
How to do this ?
thanks
Hi JCB.
Create a request in the Admin/Query phrase book
the OQL could look like this (replace Customer with the Organization name you need) : "
SELECT UserRequest WHERE start_date > :date1 AND start_date < :date2 AND org_name = 'Customer'
This is for UserRequest, but you can use a different class depending on your needs, like Incident, Change ...
Also, you can remove the DATE filter if you don't need. (date should be in the aaaa-mm-dd format)
After you've created the Query in the phrase book, you will notice a URL to use for MS-Excel web queries. Try open it in Excel and you are done. All you have to do is customize your excel file.
Hope this helps
You can also JOIN lnkContractToService at your query to define it in more details.