Location last system update

[michelle kirk]

Hi,

I am looking to add a widget to my dashboard that shows the last time Locations were updated in Service Now.

I can run the number of Locations that are active but cant find a way of getting just a date 

Is this possible ?

Reason asking we have identified and issue where our platform providers have admitted that the data hasnt been updated since 2019, so I want to be able to monitor the updates 

[michelle kirk · Accepted solution]

Hi, 

I can get it to do that - but I want it to just report on the last system update - so it provides me just one date figure, without having to go into a list and view 

Is that possible ?

[Shivalika · Accepted solution]

Hello @michelle kirk 

So you want something like interactive filter. Where you choose the location and are present with their last updated date ? 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY 

[Shivalika]

Hello @michelle kirk 

You can just generate a report on cmn_location table with filter that Updated is at or before 1 year ago or 2 year ago - it will give you list of locations which were last updated long ago. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[michelle kirk · Accepted solution]

Hi, 

I can get it to do that - but I want it to just report on the last system update - so it provides me just one date figure, without having to go into a list and view 

Is that possible ?

[Shivalika · Accepted solution]

Hello @michelle kirk 

So you want something like interactive filter. Where you choose the location and are present with their last updated date ? 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY 

[michelle kirk · Accepted solution]

Hi

No, that's not what I am after,  I just want to know the last date that the system updated the locations from the import