-
Notifications
You must be signed in to change notification settings - Fork 0
SQLAdmin Inventory sources
These external sources for Microsoft SQL Server will be part of the SQLAdmin Inventory informations.
To decouple the technologies in the import flow to SQLAdmin Inventory it is considered to implement each source as a JSON web service. JSON is preferred to XML by performance considerations. The webservice could be implemented by WCF using C#.
The extract part of the import could be done by WCF using C#. A prototype will most likely be by PowerShell. If a source if transported by HTTPS or otherwise secured the connection must be fully checked.
The Microsoft Product Lifecycle on SQL Server holds vital information about version support. Usually this kind of information is handled manually, but it is the ambition to automate a regular extract of the data and import these data to SQLAdmin Inventory.
Besides Product Lifecycle information on SQL Server the SQLAdmin Inventory should also hold similar data on Windows Server Product Lifecycle to ensure good governance on the entire technology stack.
This private and widely recognized list of SQL Server version numbers with relevant metadata. These data will add good value to SQLAdmin Invorntory and should be added. Again these data usually handled manually but the ambition must be to add data automatic on a regular basis.