You can also schedule the import to run at a set time. With this information in the system, you can manipulate the data with transform maps just like you would a spreadsheet or LDAP query. The database is probably locked down, but this information can pass through the MID Server, so the cloud isn't touching your server directly. Once you have this query planned, put the credentials, server name, and database information into a Data Source record with type set to JDBC. Note that LANSweeper may change their schema in between versions, so you'll want to work with the application owners during upgrades.
From there, start experimenting with SQL Queries to assemble a single table that gives you the data you need. Unfortunately, I cannot recall what we used as a base table, but someone familiar with SQL Server Management Studio can help you navigate the tables and find the information you need. Simply create a local, read-only MS SQL account and browse through the schema. Lansweeper hosts its data on a MSSQL database, so you can easily hook into the system using the JDBC Data Source drivers. My old company used Lansweeper to populate the CMDB because it was one of the only tools that contained our full UNIX and Windows environment.
0 kommentar(er)
