Skip to content

Instantly share code, notes, and snippets.

@Nillth

Nillth/Qlik-Sense-Example-Audit.ps1

Created March 14, 2023 22:45
Show Gist options
  • Save Nillth/e9e9db7d61c9403b602bf448a9ca13a4 to your computer and use it in GitHub Desktop.
Save Nillth/e9e9db7d61c9403b602bf448a9ca13a4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Qlik-Sense-Example-Audit.ps1
Connect-QlikSense -TrustAllCertificates
#System Audit API
#$ResourceTypes = "AnalyticConnection", "App", "App.Object", "CompositeEvent", "ContentLibrary", "CustomPropertyDefinition", "DataConnection", "OdagLink", "OdagLinkUsage", "OdagRequest", "ReloadTask", "SchemaEvent", "Stream", "Tag"
$ResourceType = "App"
$QSAuditParameters = New-QSAuditParameters -ResourceType $ResourceType
$QSAuditCountParameters = New-QSAuditCountParameters -ResourceType $ResourceType
$AuditRuleCount = Add-QSSystemrule -AuditCountParametersObj $QSAuditCountParameters -SecurityAuditCountresources
$AuditResponse = Add-QSSystemrule -AuditParametersObj $QSAuditParameters -SecurityAudit
$AuditResponse
#System Audit Matrix
#https://help.qlik.com/en-US/sense-developer/May2022/Subsystems/RepositoryServiceAPI/Content/Sense_RepositoryServiceAPI/RepositoryServiceAPI-Security-Rule-Audit-Get-Audit-Rules-Matrix.htm
$QSAuditMatrixParameters = New-QSAuditMatrixParameters -ResourceType $ResourceType -Actions Read,Update,Delete,Publish -OutputObjectsPrivileges $([QlikSenseCLI.Model.SecurityActions]::Read) -ResourceProperties "Name","id" -SubjectProperties "name","userid","userdirectory","id" -AuditLimit 1000
$QSAuditMatrix = Add-QSSystemrule -AuditMatrixParametersObj $QSAuditMatrixParameters -SecurityAuditMatrix -Verbose
$QSAuditMatrix
#Using "Splat" makes it easier to read
#https://help.qlik.com/en-US/sense-developer/May2022/Subsystems/RepositoryServiceAPI/Content/Sense_RepositoryServiceAPI/RepositoryServiceAPI-Security-Rule-Audit-Get-Audit-Rules-Matrix.htm
$paramNewQSAuditMatrixParameters = @{
ResourceType = $ResourceType
Actions = 'Read', 'Update', 'Delete', 'Publish'
OutputObjectsPrivileges = $([QlikSenseCLI.Model.SecurityActions]::Read)
ResourceProperties = "Name", "id"
SubjectProperties = "name", "userid", "userdirectory", "id"
AuditLimit = 1000
}
$QSAuditMatrixParameters = New-QSAuditMatrixParameters @paramNewQSAuditMatrixParameters
$QSAuditMatrix = Add-QSSystemrule -AuditMatrixParametersObj $QSAuditMatrixParameters -SecurityAuditMatrix
$QSAuditMatrix
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment