Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-20-2013 03:17 PM
Hi,
we neeed to make report with this parameters:
column 1 - User name
column 2 - all devices with any relationships with selected user
column 3 - devices serial numbers
Can you help me please?
we neeed to make report with this parameters:
column 1 - User name
column 2 - all devices with any relationships with selected user
column 3 - devices serial numbers
Can you help me please?
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-29-2013 12:43 PM
A sample report can be seen below.
Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tsysAssetRelationTypes.ReverseName As RelationType,
tblAssetUserRelations.StartDate As RelationStartDate,
tblAssetUserRelations.Lastchanged As RelationLastchanged,
tblAssetUserRelations.Comments As RelationComments,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename As AssetType,
tblAssetCustom.Serialnumber,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblADusers
Inner Join tblAssetUserRelations On tblADusers.Username =
tblAssetUserRelations.Username And tblADusers.Userdomain =
tblAssetUserRelations.Userdomain
Inner Join tblAssets On tblAssets.AssetID = tblAssetUserRelations.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysAssetRelationTypes On tsysAssetRelationTypes.RelationTypeID =
tblAssetUserRelations.Type
Order By tblADusers.Userdomain,
tblADusers.Username,
RelationType
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-29-2013 12:43 PM
A sample report can be seen below.
Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tsysAssetRelationTypes.ReverseName As RelationType,
tblAssetUserRelations.StartDate As RelationStartDate,
tblAssetUserRelations.Lastchanged As RelationLastchanged,
tblAssetUserRelations.Comments As RelationComments,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename As AssetType,
tblAssetCustom.Serialnumber,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblADusers
Inner Join tblAssetUserRelations On tblADusers.Username =
tblAssetUserRelations.Username And tblADusers.Userdomain =
tblAssetUserRelations.Userdomain
Inner Join tblAssets On tblAssets.AssetID = tblAssetUserRelations.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysAssetRelationTypes On tsysAssetRelationTypes.RelationTypeID =
tblAssetUserRelations.Type
Order By tblADusers.Userdomain,
tblADusers.Username,
RelationType