Highlighted
Absent Member.
Absent Member.
425 views

HPSM AGING TICKET

I would like to pull a report from HPSM or create a report, where I can add how old is the ticket from the date it was open and till todays date

 

Current query :

problem.status isin {"Pending Customer", "Pending Vendor","Work in Progress"} and assignment isin {"GLOB-APS-CONDOR-PCO", "GLOB-SAG-CONDOR-EUS"} and ( open.time>=tod()- '8 00:00:00' and open.time<=tod() - '1 00:00:00' and update.time<=tod() - '1 00:00:00') 

 

Need modify to have option to view open date of ticket and how old ticket

How old= current date -open date

When i manually pull the report to Excel ,the date dont tabulate well in excel, despite arranging the format of the report.

 

PLease help to find  fix

1 Reply
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: HPSM AGING TICKET

what text in your xls file in "current date" and "open date" ?

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.