Jump to content

Reporting on requests without a linked asset ID


AlexOnTheHill
 Share

Recommended Posts

Do you happen to know whether it is possible to report on requests that have been logged that do not have a linked asset ID?

I know how to report to see which asset IDs are most frequently used however we also need to report on requests missing the linked asset so we know whether training is required or if the asset needs to be created.

 

Many thanks

Link to comment
Share on other sites

The links between Requests and Assets are stored in the h_cmdb_links table.

I'm sure this is possible, although frankly beyond my SQL skillset, but you'd need to convert the Request Reference into a URN and then find which Requests did not have an entry in that table - I know how to do the opposite, but for this you're finding something that isn't there, which is a bit more of a challenge.

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...