how to extract all tickets information from MVM database, including ticket creation date, closed date, status of ticket and related scan template name for the tickets.
You can run
select * from tickets. This will give result but IP is in long format.
Use following query, this will give exact same result with IP v4 format
HostWebAssetID from tickets
Hope this help
thanks for your reply.
However would it be possible to have the query results showing each tickets relating to their respective scan template name?
just like when we do a search tickets in MVM.