Search
-
Assets -> get creation date, modified date ...
Hi all, I query the scsmdwh db to get a complete list of all assets with their properties but I can't find the creation date property anywhere. After some research I found a link that says this should be inside the operational db - entitylog, but this seems extreme complex for such a simple question. Is it really the only… -
Re: Missing properties/fields when getting activities from SCSM
-
User blocked after get the password wrong once
-
SQL Query to get a Manual Activity's (MA's) parent Change Request (CR)
-
How to get effective asset reporting?
I am attempting to get some asset reporting together. Nothing super crazy, ideally I want to have a report e-mailed out to management and the inventory team listing all systems that should be in stock. One of the canned reports is pretty close to what I need, but it does not included the Manufacturer or Model Enum values,… -
Re: Renaming of Support Groups does not get reflected in the portal
-
Get a value from SR to use in a P$A
Hello, I sincerely apologize if this has been answered.... I am looking to ask a question (ex. What is your favorite color?) I would then like to take that input and make it a variable to pass to a spreadsheet. I have mapped the input to the "notes" field of the form, but it doesn't seem to work. I am new at all this so… -
SQL - Getting a Service Request priority in ServiceManagement
Hello All, When returning IR's and SRs from the WorkItem table I'd like to output Priority. With SR's it gives me a GUID and with IR's it gives me a number. SQL gets angry (types in red characters back at me!) when I join the Display table's ElementID field to the WorkItem's PriorityID field (Conversion failure...character… -
Re: After updating to Cireson portal to 11.6.3 we get this error with the Cache Builder.
-
Cireson API to Get Custom Class Objects with Properties
Hi All, What is the best way to get Class Object's including their sub properties using the Cireson API without using a Type Projection call. We have got the Type Projection API working, but it is to slow even for 300 objects. We also cannot use the Base call to get the classes the Cireson API Advertises as it does not…