‎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