Dashboard / Reporting on Pending Approvals

[rsanon]

Has anyone created dashboard that shows the age of pending approvals?

For instance, a dashboard that shows outstanding approvals for 2/3.5/5 days along with the Approval type (Change, Requested Item, etc).

Right now, we just have a report that shows created relative on or after x amount of days. And Approval Start with RITM or CHG etc...

If any one has done something edgy and want to share some ideas

[poyntzj]

Not here, we just show outstanding approvals

I may look at as it could be useful, but initially I would look at styles and change one of the fields colours

[mayan]

Pending Approval Request Email Notification. Scheduled Jobs

-------------------------------------------------------------------------------------------------

var queryString = "state=requested";

var approval = new GlideRecord('sysapproval_approver');

approval.addEncodedQuery(queryString);

approval.query();

while (approval.next())

{

event = "App.reminder";

gs.eventQueue("App.reminder", approval, gs.getUserID(), gs.getUserName());

}