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.
Related posts
Streamlining ISO 27000 Compliance: A Comprehensive Guide
Streamlining ISO 27000 Compliance using IT inventory: A Comprehensive Guide In today's digital age, data security is paramount. Organizations are continuously striving to safeguard their sensitive information and maintain the highest standards of data security.
vScope 3.27.0
vScope 3.27 3.27.7 September 21, 2023 Improvements Easily customize your table with quick filters for faster data manipulation The aggregation bar in tables is now expandable, allowing you to customize it
Introducing IP Insight – the ultimate tool for documenting IP addresses
PRODUCT UPDATE Introducing IP Insight - the ultimate tool for documenting IP addresses As a part of vScope's IT inventory platform, IP insight provides you with a comprehensive overview of all IP addresses discovered by