Automating End-of-Life/End-of-Support data in ServiceNow for operating systems or software

[Timothy Onyskin]

Has anyone been able to automate the End-of-Life/End-of-Support data in ServiceNow for operating systems or software?  I'm trying to easily get the information whether by API or some other method into a spot in ServiceNow so we can enhance our discovery data.  I hit a few roadblocks right off the bat... 1) can't find any APIs out there to link into so I can't get the data easily; 2) not quite sure where it belongs;

Any help would be great.

[Ashutosh Munot1]

Hi,

Not clear enough what you are looking for. 

We have CMDB Api in place so you can use that. Go to REST API Explorer in left navigation to get the details.

Thanks,
Ashutosh

[Timothy Onyskin]

Here is the scenario I am attempting to do.

1) Discovery finds and discovers a server with the operating system and middle-ware.

2) CIs are added to the CMDB.

3) API is called to external site (don't know where) to query the OS and bring back the end-of-life and end-of-support dates.

4) Information from step 3 is added (don't know if there is out of box fields, if it should be on the CI, or if this is in the Asset module) so that if someone wanted to run a report or query, they could see any CI that needed to be included in a tech refresh for... before Today, relative after 3 months from now, in July, etc...

The two areas that are underlined in my above scenario are the parts I need to find out if anyone has any insight.  I can build outbound APIs, but I do not know if anyone has found a source that has this data and once I have the data, I do not know if there is already a proper place to put this sort of thing, or if I should just create some custom fields.

[Ashutosh Munot1]

HI,

So i far as i know this data is not discovered by discovery. If this data is stored in some database in your organisation then definitely you can pull that data into servicenow. We have SQL data source which can be used same like SCCM integrations.

Then you need to stores this information on asset/ci using new fields or try to utilise some other OOB field.

So you need to check where the OS info is stored.

Thanks,
Ashutosh

[Timothy Onyskin]

That is what I was thinking of doing but my company does not have a repository with the data so I was hoping that someone knew of any public APIs to connect to and if there is already OOTB fields for this data or if I have to make custom fields.  From what I am gathering from your reply, you have to gather the data yourself and figure out wherever you want it (there is no standard that ServiceNow has unlike the BMC products that server it to you on a silver platter).