Page Listing IR/SR by Affect User attribute

Dana_HazzardDana_Hazzard Customer IT Monkey ✭
Hello,

I want to create a page that shows both incidents and service requests based on the affected users active directory attribute.  In this example, the users Company attribute.  I would like to have both the count widgets (for IR/SR respectively) as well as list the incidents and service requests.

Can anyone offer some assistance?

Answers

  • Brian_WiestBrian_Wiest Customer Ninja IT Monkey ✭✭✭✭
    Quick example to get started
    Affected user AD Department of NOC, off the live ServiceManagement DBO

    Select * from WorkItem
    LEFT join [dbo].CI$User AffectedUser on AffectedUser.Id = Workitem.AffectedUserId
    Where AffectedUser.Department = 'NOC'
Sign In or Register to comment.