Connect to a custom SQL database

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

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