Monday, Sep 06, 2010
Login

Category: Reporting

Automatically Filter Report Homepage

I

just figured out a cool little reporting feature today that might end up helping somebody. On the reports homepage (‘report_home.do’) in Service-now.com, users have the ability to type filter text to restrict the types of reports that they see. So, if I wanted to see just those reports on the ‘Change request’ table, I could simply type ‘change request’ for my filter text as shown below…

Now for the cool part…


Group Member Counts Reports

O

ver the last couple of weeks I’ve seen the same type of question a few times. The questions center on group membership reporting and usually look something like the following…

“How can I generate a report showing which groups in my system have no users?”
“How can I generate a report showing which groups have no active users?”
“Is it possible to report on the number of active users in a group?”


Exporting a Report Directly to FTP

Scheduled Data Extract

S

ervice-now provides numerous ways of getting data into the system. The import set functionality supports pulling data in from an attachment, FTP(S) servers, JDBC data sources, etc. However, a common problem that many customers have is trying to get data out of their SN instance and into their data center. The simplest way to handle this currently is by having a report emailed to you on a scheduled basis. There has to be a better way!

Scheduled Data Extract ModulesThe good news is that there is a better way. The “Scheduled Data Extract” update set has been designed to allow a user to have reports, tables, or table views sent to a specific directory on a local mid server or FTP to a customer’s FTP/FTPS server on a scheduled basis. The “Scheduled Data Extract” update set has been battle-tested and is used by several large Service-now customers today.


Viewing CI Subscription Notifications

T

he Subscription-based Notification plugin allows Service-now users to manage their subscriptions for any notification in the system. It also allows users to subscribe to particular Configuration Items in your CMDB that they may be interested in.
As an administrator or process owner, it may be necessary for you to be able to view or report on which users have subscribed to updates for a particular configuration item. You may also want to see what configuration items a particular user has subscribed to without opening up their subscriptions page.


 

Recent Comments

  • Scott Stechmesser: Awesome script to use. Works great. How would you modify it to be able to copy a Catalog UI Policy?
  • Tulio: Perfect!!! Thanks for this.
  • Ron Methias: Another reason why I have stopped going to the official SN documentation sites and make the GURU my...
  • Richard Huss: Ingenious – and somewhat simpler than the way the Incident Resolution best practice plugin does...
  • valor: Joe, that’s one of the reasons why I’m parsing out the URL instead of trying to get the page...