Lansweeper and QlikView integration + automation

[AlexBell]

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!

[hubertmroz · Accepted solution]

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.tblAssets	List of assets
dbo.tblAzureAdUser	Scanned AzureAD users.
dbo.tblBitLockerRecoveryKey	List of scanned bitlocker recovery keys
dbo.tblLinuxUser	Table containing local users of linux servers, which are connected via AssetID column.

[AlexBell]

Thank you!