cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AlexBell
Engaged Sweeper II

Hi!

Please tell me how to organize the integration of Lansweeper and Qlikview. I'm new to using both systems. Can you tell me something.

Thanks!

1 ACCEPTED SOLUTION
hubertmroz
Engaged Sweeper II

Hi,

Never worked with qlikview, but helped my PM to get it working with PowerBI.
Create sql user for BI reporting.

--- T-SQL
-- create sql user
create Login lansweeperuser_powerbi WITH password = 'passwordgoeshere'
-- grant 'db_datareader'to your SQL user
use lansweeperdb
go
exec sp_addrolemember 'db_datareader', 'lansweeperuser_powerbi'
go

 Connect qlikview to your lansweeper sql database as in YT video

Connecting Qlik Sense to Microsoft SQL Database - YouTube

And now, you gotta know what information you wanna gather into qlik.
Here are some examples:

dbo.tblAssetsList of assets
dbo.tblAzureAdUserScanned AzureAD users.
dbo.tblBitLockerRecoveryKeyList of scanned bitlocker recovery keys
dbo.tblLinuxUserTable containing local users of linux servers, which are connected via AssetID column.



View solution in original post

2 REPLIES 2
hubertmroz
Engaged Sweeper II

Hi,

Never worked with qlikview, but helped my PM to get it working with PowerBI.
Create sql user for BI reporting.

--- T-SQL
-- create sql user
create Login lansweeperuser_powerbi WITH password = 'passwordgoeshere'
-- grant 'db_datareader'to your SQL user
use lansweeperdb
go
exec sp_addrolemember 'db_datareader', 'lansweeperuser_powerbi'
go

 Connect qlikview to your lansweeper sql database as in YT video

Connecting Qlik Sense to Microsoft SQL Database - YouTube

And now, you gotta know what information you wanna gather into qlik.
Here are some examples:

dbo.tblAssetsList of assets
dbo.tblAzureAdUserScanned AzureAD users.
dbo.tblBitLockerRecoveryKeyList of scanned bitlocker recovery keys
dbo.tblLinuxUserTable containing local users of linux servers, which are connected via AssetID column.



AlexBell
Engaged Sweeper II

Thank you!