Linking Support groups from dbo.ci to dbo.WorkOrder
I can get the created support groups by
select * from [dbo].[CI] where CITYPEID = 8
which gives me the columns
- CIID
- CITYPEID
- CINAME
- DESCRIPTION
- LABEL
- CREATEDDATE
- LASTMODIFIED
- VERSION
- LIFECYCLEGROUPIDENTIFIER
- SITEID
How can I link this to the primary workOrder table e.g.
select * from dbo.WorkOrder ?
Fot most entries in dbo.WorkOrder the CIID column is NULL, so I assume this is not the way to do it.
Topic Participants
Daniel Arnfeldt
Dinesh Bhaskaran
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?