06-05-2023 07:29 AM - last edited on 04-01-2024 02:19 PM by Mercedes_O
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!
Solved! Go to Solution.
06-05-2023 08:37 AM
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. |
06-05-2023 08:37 AM
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. |
06-05-2023 09:27 AM
Thank you!
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now