Back to feed

Connect to a custom SQL database

vScope’s custom SQL integration allows teams to further centralize assets, reports and documentation about its IT

February 5, 2021

vScope 3.17 introduces a new, flexible integration that to a greater extent allows teams to centralize asset documentation and reports on the same platform. The Custom SQL integration enables an even more flexible inventory than the very popular Excel import which is widely used to import tags to various assets from .xlxs files.

Unlike the Excel import, Custom SQL is part of vScope’s discovery. This means that you can also create new assets and customize the format of tags. Furthermore, you can configure your Custom SQL queries to run automatically whenever you want using discovery schedules.

Fetch warranty dates, costs, notations, new assets and more

With Custom SQL it’s easy to get additional data into vScope, which is currently not available in existing integrations. Fetch warranty status from a warranty management system, costs from a BI system, or SLAs from your service desk. If you currently document assets in an asset management system there are good chances that you can collect them into vScope using the Custom SQL integration.

It’s easy to get started!

You can use Custom SQL to connect vScope to a SQL database, such as Microsoft SQL or MySQL, to fetch new assets and tags. vScope needs to be able to connect to a database using an account with reading permission. You will receive direct feedback in vScope if something’s wrong. Now you are ready to run a custom SQL query to fetch a table from the database.

Notice that the resulting table must include sufficient identifiers for vScope to stitch them with existing assets, or add them as new. Once a connection is established you can use vScope’s Tag manager to customize which columns to extract to tags.

When configured, vScope will automatically fetch values, update information and create new assets from the database.

What’s next?

If you are already running vScope, you should follow this guide to setup a Custom SQL integration. If you are currently not aboard the vScope train we can arrange a demo to show how your team can benefit from centralizing IT asset reporting and documentation.

Don’t hesitate to contact us with any feedback or questions regarding extended IT inventory.

Contact Customer Success

Related posts

Suggestions to help you improve data quality

January 21st, 2022|0 Comments

PRODUCT UPDATE Suggestions to help you improve data quality vScope automatically helps you to minimize the number of duplicate assets from multiple data sources by matching numerous criteria. Suggestions are

Directory Machines migrated to All Machines

January 20th, 2022|0 Comments

PRODUCT UPDATE Reclassification of asset types that might affect license limits PUBLISHED JANUARY 21, 2022 Search for any computer, view computers from Active Directory in Properties, and easily find deviations between

Two reports to find out where you are using Log4j

December 17th, 2021|0 Comments

PRODUCT Two reports to find out where you are using Log4j A flaw in Apache Log4j allows an attacker to execute arbitrary code by injecting attacker-controlled data into a logged