This report shows Azure license skus assigned to users. It is optionally filterable by last logon timestamp for Exchange. This may be used to identify users that may have unrequired licenses. This report uses join rules to display information about a user’s manager to provide contacts for further inquiry.
{
"Data": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
"Id": "3468e8d0-6eab-4577-8493-d093de071ab6",
"Name": "Office 365 Licenses",
"UserId": null,
"UserProfile": false,
"Tags": [
"O365"
],
"Roles": null,
"CacheExpiration": "12:00:00",
"Description": null,
"Parameters": [
{
"$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
"Name": "Days",
"Description": "Number of days since user logged in. Leave blank to include all users",
"Required": false,
"Validation": "Double",
"DefaultValue": "30"
}
],
"DataSets": [
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Aliases": null,
"MapRule": "",
"Name": "License",
"Type": "SoftwareIDM.AzureModel.AzureRecord, SoftwareIDM.AzureModel",
"Clauses": [
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "Silo",
"Operation": "Eq",
"Value": "special.Identity Silo.Office 365: MSOnline"
},
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "ObjectType",
"Operation": "Eq",
"Value": "\"AccountSku\""
}
],
"SubQueries": []
},
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Aliases": null,
"MapRule": "",
"Name": "License - MsolUser",
"Type": "SoftwareIDM.PanelModel.Models.MultiAttr, SoftwareIDM.PanelModel",
"Clauses": [
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "Silo",
"Operation": "Eq",
"Value": "special.Identity Silo.Office 365: MSOnline"
},
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "Attribute",
"Operation": "Eq",
"Value": "\"Licenses\""
}
],
"SubQueries": []
},
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Aliases": null,
"MapRule": "",
"Name": "MsolUser",
"Type": "SoftwareIDM.AzureModel.AzureRecord, SoftwareIDM.AzureModel",
"Clauses": [
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "Silo",
"Operation": "Eq",
"Value": "special.Identity Silo.Office 365: MSOnline"
},
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "ObjectType",
"Operation": "Eq",
"Value": "\"User\""
}
],
"SubQueries": []
},
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Aliases": null,
"MapRule": "",
"Name": "Mailbox",
"Type": "SoftwareIDM.AzureModel.AzureRecord, SoftwareIDM.AzureModel",
"Clauses": [
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "Silo",
"Operation": "Eq",
"Value": "special.Identity Silo.Office 365: Exchange"
},
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "ObjectType",
"Operation": "Eq",
"Value": "\"Mailbox\""
}
],
"SubQueries": []
},
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Aliases": [
"MVManager"
],
"MapRule": "",
"Name": "MVUser",
"Type": "SoftwareIDM.SyncModel.MVRecord, SoftwareIDM.SyncModel",
"Clauses": [
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "Silo",
"Operation": "Eq",
"Value": "special.Identity Silo.FIM: Metaverse"
},
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "ObjectType",
"Operation": "Eq",
"Value": "\"user\""
}
],
"SubQueries": []
},
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Aliases": null,
"MapRule": "",
"Name": "User - Manager",
"Type": "SoftwareIDM.PanelModel.Models.MultiAttr, SoftwareIDM.PanelModel",
"Clauses": [
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "Silo",
"Operation": "Eq",
"Value": "special.Identity Silo.FIM: Metaverse"
},
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "Attribute",
"Operation": "Eq",
"Value": "\"manager\""
},
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "Deleted",
"Operation": "NotExists",
"Value": ""
}
],
"SubQueries": []
}
],
"ReportSets": [],
"Relations": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
"Name": "License - Ref",
"LeftSet": "License",
"RightSet": "License - MsolUser",
"LeftRule": "Id",
"RightRule": "Value",
"AllowLeftOuter": false,
"AllowRightOuter": false
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
"Name": "LicenseRef - MsolUser",
"LeftSet": "License - MsolUser",
"RightSet": "MsolUser",
"LeftRule": "ObjectId",
"RightRule": "Id",
"AllowLeftOuter": false,
"AllowRightOuter": true
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
"Name": "MsolUser - Mailbox",
"LeftSet": "MsolUser",
"RightSet": "Mailbox",
"LeftRule": "Links.0.Other",
"RightRule": "Id",
"AllowLeftOuter": false,
"AllowRightOuter": false
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
"Name": "MsolUser - MV",
"LeftSet": "MsolUser",
"RightSet": "MVUser",
"LeftRule": "Attributes.UserPrincipalName",
"RightRule": "Attributes.userPrincipalName",
"AllowLeftOuter": false,
"AllowRightOuter": true
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
"Name": "MVUser - Manager Ref",
"LeftSet": "MVUser",
"RightSet": "User - Manager",
"LeftRule": "Id",
"RightRule": "ObjectId",
"AllowLeftOuter": false,
"AllowRightOuter": true
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
"Name": "Manager Ref - Manager",
"LeftSet": "User - Manager",
"RightSet": "MVManager",
"LeftRule": "Value",
"RightRule": "Id",
"AllowLeftOuter": false,
"AllowRightOuter": false
}
],
"FieldProjections": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "License SKU",
"RelationName": "License - Ref",
"RelationSide": "Left",
"ValueRule": "DN"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Mail",
"RelationName": "LicenseRef - MsolUser",
"RelationSide": "Right",
"ValueRule": "$\"{TimeTraveler(Id)}|{Attributes.UserPrincipalName}\""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Last Logon Time",
"RelationName": "MsolUser - Mailbox",
"RelationSide": "Right",
"ValueRule": "DateTimeFormat(Attributes.Last Logon Time, \"yyyy-MM-dd hh:mm\")"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Out of Office",
"RelationName": "MsolUser - Mailbox",
"RelationSide": "Right",
"ValueRule": "If(Attributes.Auto Reply State != \"Disabled\", \"Yes\", \"\")"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Display Name",
"RelationName": "MVUser - Manager Ref",
"RelationSide": "Left",
"ValueRule": "If(DN, DN, \"On premise account not found\")"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "EmployeeID",
"RelationName": "MVUser - Manager Ref",
"RelationSide": "Left",
"ValueRule": "Attributes.employeeID"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Manager",
"RelationName": "Manager Ref - Manager",
"RelationSide": "Right",
"ValueRule": "If(DN, DN, \"No Manager for User\")"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Manager Mail",
"RelationName": "Manager Ref - Manager",
"RelationSide": "Right",
"ValueRule": "Attributes.mail"
}
],
"Transformations": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
"FilterRule": "If(Memo(\"Days\"), CoerceDateTime(Data.Last Logon Time) < AddTime(Now(), Days(\"-\" + Memo(\"Days\"))), true)",
"GroupingRule": "",
"TransformRules": []
}
],
"Styles": [],
"Sort": {
"Field": "Last Logon Time",
"Direction": "Descending"
}
}
],
"Count": 1
}
Comments
0 comments
Please sign in to leave a comment.