Home Analytics

how to query "assigned by"

Service_Desk2Service_Desk2 Member IT Monkey ✭


i'm trying to write an report which will tell me which analyst assigned which workitem to what group/user.

But i cant find a "assigned by" column anywhere in the database. Since this is shown in the history tab in the ticket the information should be somewhere in the database.

anyone knows where?

// Erik


  • Konstantin_Slavin-BoKonstantin_Slavin-Bo Customer Ninja IT Monkey ✭✭✭✭

    AssignedBy is not a property field in it's own, but the information is stored in the history. There won't be a AssignedBy there either, but you should be able to find when a relationship change of the type you are looking for occurred (Relationship change of Assigned To User), and look up which user made the change.

    I have no idea where it's stored in the CMDB, but you need to find a table containing History of the WIs.

    In Powershell you can use the Get-SCSMObjectHistory cmdlet to get the info, maybe you can find some clues there.

  • Service_Desk2Service_Desk2 Member IT Monkey ✭

    Thank you, i will keep looking!

Sign In or Register to comment.