Jump to content

Report on Users who do not have specific asset types assigned/lined to them

Francis von Stein

Recommended Posts

Hi @Francis von Stein

I've taken a look at this one this evening but unfortunately I'm not convinced I have a way this can be achived. The main issue is the way that Hornbill stores the "Used By" data in the h_cmdb_assets data - it's like this:

urn:sys:0:Brad Johnson:bradj

This means it's very difficult to get a join to the other tables that a required here. The possibly is a complex way I could formulate a join but unforunately the type of report you are requesting is quite a difficult one to build and is not suited to our reporting interface. 

I can possibly get the SQL that you could run to generate this, but it would have to be run at the Database Direct level (by someone who has the Super User role). I'll ask internally too to see if there is anything else that can be done here. 

Sorry about this one!



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
  • Create New...