Create a Report to see Catalogs with Excel Template

[salwaabedi]

Hi!

In our instances there are some catalogs which have links in them. These links are redirecting the Users to Excel files. How can I identify how many Catalog items in the system have such links. 

I wanted to run a report to view this but cannot determine which tables to use. Please assist. 

[Allen Andreas]

Hello,

How are the links in the catalog items? In the description section? If so, then you can run a record on catalog item table where description contains keyword and that will show you a report with them.

[salwaabedi]

The text is different in each catalog description. However when you click on these links it redirects user to a google sheet with .xlsx. I am trying to identify how many catalogs have such links which redirect users to .xlsx sheets in the title. 

[Brian Lancaster]

If the attachments are in ServiceNow and not pointing to a SharePoint site. You could have a condition like description contain href="sys_attachment.do since the description is html. This will pull back everything not just excel however if there are items that have other attachments.

If the attachments are outside the system you might be able to description contains .xlsx if that is in all the URLs.

[Allen Andreas]

Hi @salwaabedi 

have you attempted to try what I mentioned in my initial reply? Regardless of what you're seeing as the text, please try per what I mentioned.