I am trying to ETL data out of my ServiceNow instance and into a SQL Server DB. I am extracting data via the ODBC driver, and I'm using SSIS as my ETL tool. I'm running into a problem with my ODBC source in my data flow task. In SSIS, I have create...
Hi everyone,I've seen quite a few threads around this topic but was wondering if anyone actually found success with importing Knowledge Articles with images into ServiceNow, particularly with Microsoft Word and PDF documents. We tried the inbound e...
Hi , I'm using the below code to escape single backslash that is present in my JSON payload json_payload.replace("\\","\\\\"); This works fine when the payload contains single backslash. eg {"name": "\xyz"} This gets converted to {"name": "\\xyz"} bu...
We're running into an issue where right now we are using Scheduled Jobs to kick off a script include that uses a MID Server to connect to a 3rd party system for importing data into a ServiceNow table directly. What we want to do is use Import Sets an...
I want to embed an image in email template from sys_attachment table, as I have added the attachment in change_request table and when i open form view and click View attachment below URL is shown with corresponding image, but as i need to embed thi...
Hi, I am trying to call a subflow from a business rule but it doesn't work. Could someone please check what I am missing. I am running the business rule on after update and this is the code snippet: (function executeRule(current, previous /*null when...
I was building a report today based on the "Did this article help you?" question that appears on articles in our knowledge base and hit a bit of a snag. I didn't know which table or what grouping to use. When I checked the documentation for tables, i...
Hello, For a requirement on a Catalog Item, I need to add the comments from an approval to the RITM description. I will post an image of the current flow and script below, but I am running into an issue. The script works for the first few approval...
Hi All, I am using Kingston Patch 12 version, where I am having an issue with the Primary IP Address field of the CIs. All of the classes which have this field is not getting updated such as Routers, Firewalls, etc. Whenever I am trying to update the...
Hello, I've done searches regarding this topic and it appears that this shouldn't be something that is as hard as it's been for me. I have a situation where I want the Short Description for the Task (TASK) ticket that's created to use the Short Desc...
All our Configuration Items were loaded into two custom tables. We have routers, switches, and other devices loaded into the custom tables rather than the Out of the Box locations provided by ServiceNow. What functionality is lost by not using the O...
Hello, I've seen numerous articles posted about retrieving the Manager of a currently logged in user, however, none of the examples are working for me. It appears as if the getManagerID() and getManagerName() function/methods simply aren't enabled, i...
How to create parallel tasks in workflows?
Hi, The below one is Contract Form: The below one is Workflow for Contract Approvals. When Contract is Submitted(By default status is draft after submitting the contract status changes to Under Review) then Approver got the notification...
