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
I think smlets gets all extensions of a class, when you get the OOB class, where Orchestrator gets the actual class without extension, when you select the OOB class. Either way, it seems weird, that you don't get any more properties that GUID. To be clear, you are using these IPs, right?… -
User blocked after get the password wrong once
Hello Community, I have a problem here on my SCSM. Every time a user was the password once, our AD locks the user. We have a GPO that allows the user to get it wrong up to 3 times. Does anyone know how to adjust this? Best Regards, Joao Araujo -
SQL Query to get a Manual Activity's (MA's) parent Change Request (CR)
Trying to figure out how to get a Change Request's (CR's) child Activities (RA, MA, PA, SA, etc.). -
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
No worries let me know how you get on! Thanks, Shane. -
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… -
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… -
Re: After updating to Cireson portal to 11.6.3 we get this error with the Cache Builder.
Is there an update on this, as we get the same error?
>2919 results