I trying to extract the value of a custom field with property type “l: system lookup”.The lookup_VAL_ID does not seem to match anything in the jptsys_web_lkup_dataAlso what is weird is we are on 11.6.3 and table jptsys_web_cust_prop is not supposed to be removed 11.5 but it is there and it is populated with something!!!here is the SQL that I use to get the “Lookup_val_ID”:(select max(convert(varchar,jc.LOOKUP_VAL_ID)) from jptsys_web_cust_prop_cont (NOLOCK) jc left join jptsys_web_cust_prop (NOLOCK) j on jc.jptsys_web_cust_prop_id=j.jptsys_web_cust_prop_id left join jptsys_web_lkup_data (nolock) drop_dwn_val on drop_dwn_val.jptsys_web_lkup_data_id = jc.LOOKUP_VAL_ID left join jptsys_web_lkup (NOLOCK) lkup on drop_dwn_val.jptsys_web_lkup_id = lkup.jptsys_web_lkup_id where i.incident_id=jc.entity_id and j.jptsys_web_cust_prop_sc='REGION' ) AS "Region / Région",
Hello All, Has anybody before been able to using SQL identify where a ticket is assigned (SVD) to at the point when the ticket has breached?If so would you be kind enough to share this with me
Hi everyone, is there I way (without external reporting) to report on Assyst elements that are not Events, such as SVDs, Services, groups, etc. This would be useful for housekeeping, update and/or migrations. Thank you.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.