Resolved! Delete an INCIDENT?
How can I delete an Incident?? closed or open. We deal with Patient information and a user put some sensitive information into a ticket and we would like to just delete the whole thing altogether. Is this an option?
Forum Posts
Resolved! Parent table to get an access to child table column
Hi we have a peculiar requirement. We have cmdb_ci_service as Service and also using as Business System. There is a flag in cmdb_ci_service (custom) which is a boolean field like is_service whether to false/true. False is a system and true is Service...
Keeping Gamification Fresh
Hi Everyone, The concept of gamification seems to be an excellent idea. In fact it's something my company is giving serious thought in doing because it encourages a positive behavior from everyone involved. I am however, curious about one thi...
Link Catalog Items to Knowledge article
In knowledge there is the attached tasks and affected products options. These, if turned on, will show if the knowledge article has been attached to any tasks recently or if this article is associated with any products. I want to do something like th...
ODBC Connection Fails
When running this:SELECT *FROM "SCHEMA".OAUSER.task This is the error:7/11/2014 6:59:34 AM: Error: SQL##f - SqlState: S1000, ErrorCode: 10215, ErrorMsg: [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Disk Cache file size limit ha...
Resolved! Remove an option from select box variable in the catalog item form
Hi, I have a form, with a select box variable. the option is this select box is defined question choice. Now, one of the values is no longer relevant, and i would like to deactivate it - meaning i don't want it to appear anymore for users, but i al...
Best way to export CMDB data
Dear Gurus, I read the wiki on how to export CMDB data, we need to keep a offline record. Many of the ways are interactive and thus is not very practical for routine exporting. How do you guys export CMDB records regularly? The only easy way I foun...
Possible to retrieve blobs from the sys_attachment table via ODBC?
Good day all, Just popping the question out there for anyone who might have tried this in the past. I can certainly access the table but basically I'm trying to find a method of copying across attachment blobs from Service-Now into our own databas...
Dynamically Search / Query Knowledge Base Articles
Hello everyone, I was wondering if some of those out there who a well versed in Knowledge could help me figure out a solution to a business problem I'm having. We currently have a good chunk of .pdfs, .ppts, and other documents or hyperlinks that l...
SAP Data Services data load
Did someone try to load data from ServiceNow by using SAP BusinessObjcects Data Services (BODS)?I'm trying to use it with ODBC connector. The test connection works in ODBC Data Source Administrator (to SN demo server https://demoodbc.service-now.com ...
Database view for Catalog items
In our project, the client need to create a report for a Catalog item (Report stolen device) which has 3 variables (namely - Place/Location, Type of Device, Description) and should like below - Item NameRITM numberPlace/LocationType of deviceDesc...
Service catalog variable time type
Hi,Anybody has idea about how to use only time(not date and time) as service catalog variable.Ex: 8:10 AM or 9:15 PM RegardsMano
Resolved! Product Catalog Items Not Captured In Update Sets
I've noticed that when a product model is published to the Product Catalog, the catalog item is not captured in an update set. Variables, variable sets, ui policies and client scripts associated with the item are captured in the update set, but not t...
Not seeing data in Database View??
I am currently working on a Database View, so I can do a report. The report consists of data from 3 tables (pm_project, pm_project_task and time_card). My database view that I am playing with consists of the following View Tables: On the proje...
Resolved! Filtering the knowledge base
Is there a way to filter the knowledge base by ownership group. We have a standard work category for our team and I would love to put a link that would show any articles that the topic standard work and the ownership group is one of my teams. I k...
