Re: ARS v9.0 - New Server Object - Associations

2015-05-15 Thread Thad Esser
Doug, From what I'm understanding, this feature is currently geared toward whether or not the associated records exist. Any chance it could develop into also being data-focused? For example, let's say you have a People form and someone's Full Name changes. You could then define associations to

Re: ARS v9.0 - New Server Object - Associations

2015-05-15 Thread Thad Esser
Rick, Again, having only read some of the docs, it looks like they are moving toward a flatter version of the CMDB, and I'd guess that would continue with each version. Years ago, there was a 3rd party product called Enterprise Service Suite or ESS@Work (John - is that what you were thinking

Re: ARS v9.0 - New Server Object - Associations

2015-05-15 Thread LJ LongWing
It's been a few years since I took the Force.com trainingbut I seem to remember that you could say something similar to 'I want this field on this form to be the value on that form (here is the definition of how to get the other value 'association')and then from that point forward, the two

CMDB Data Migration 8.1.02

2015-05-15 Thread Michelle Grace
Greetings All, Has anyone had any success with data migration into CMDB 8.1.02 we have tried AIE, AI and Spoon to no avail. We can use Migrator but that has some issues because we can't migrate from/to a join. This is 7.6.03 to 8.1.02. Thanks in advance for any assistance. Michelle

Re: ARS v9.0 - New Server Object - Associations

2015-05-15 Thread Jason Miller
I have also heard this plan (probably from the same source). It can be tricky though, there are times you want the historical value of some data to remain the same. For example a person's location or department. If they move to a different site and department over the years you don't want their

Re: ARS v9.0 - New Server Object - Associations

2015-05-15 Thread LJ LongWing
Rick, I wasn't discussing things that 9.x is doing...i was expounding on an idea that Thad was discussing regarding synchronizing datajust a thought...not something they are currently doing, or to the best of my knowledge, something they plan on doing :) On Fri, May 15, 2015 at 10:23 AM, Rick

Re: Sort of OT: Help with an SQL query on the AR System database...

2015-05-15 Thread Thad Esser
The same field id could exist on multiple forms with different field lengths, and as Jarl said, you need to include the schema id. Curious though, do you need the subquery? How about: select C.SCHEMAID, C.NAME, A.FIELDNAME, A.FIELDID, B.MAXLENGTH from FIELD A, FIELD_CHAR B, ARSCHEMA C where

Re: Sort of OT: Help with an SQL query on the AR System database...

2015-05-15 Thread Joe D'Souza
Nevermind.. I was not thinking right.. select C.SCHEMAID, C.NAME, A.FIELDNAME, A.FIELDID, B.MAXLENGTH from FIELD A, FIELD_CHAR B, ARSCHEMA C where (A.SCHEMAID = C.SCHEMAID) and (A.SCHEMAID = B.SCHEMAID) and (A.FIELDID = B.FIELDID) and (A.FIELDID = 100 AND A.FIELDID = 199) and

Notification for More Information approval status on a CRQ approval?

2015-05-15 Thread Danaceau, Chris
Had a user set his approval to this the other day and nothing went out to anyone (Manager or Coordinator). Went looking for a notification thinking I may have turned it off. Could not find anything that matched. Is there one? -- Thank You, Chris Danaceau FINRA 240-386-6728 (desk)

Re: Notification for More Information approval status on a CRQ approval?

2015-05-15 Thread Gadgil, Abhijeet
PL check under AP:Administration if you see AP:Notifications It should be there Regards, Abhijeet From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Danaceau, Chris Sent: 15 May 2015 23:44 To: arslist@ARSLIST.ORG Subject: Notification for More

Re: Sort of OT: Help with an SQL query on the AR System database...

2015-05-15 Thread Joe D'Souza
Yes I was not thinking right. I had that subquery before I developed the whole query and left it there and then didn't think it was not required once I brought more tables into the query. I changed it exactly to what you have down there when Jarl pointed out what I was not looking at :-).

Re: ARS v9.0 - New Server Object - Associations

2015-05-15 Thread Rick Cook
So, it's changing the degree of normalization of the data model. That doesn't sound quite like what Remedy is doing in v9, but it seems to be moving in that direction. For better or worse, that structure has defined Remedy from its competitors through the years. Rick On May 15, 2015 9:17 AM, LJ

Sort of OT: Help with an SQL query on the AR System database...

2015-05-15 Thread Joe D'Souza
I have developed this query for listing all global fields (regular and window specific) that are either of 0 length or input length above 1000. select C.SCHEMAID, C.NAME, A.FIELDNAME, A.FIELDID, B.MAXLENGTH from FIELD A, FIELD_CHAR B, ARSCHEMA C where (A.SCHEMAID = C.SCHEMAID) and

Re: Sort of OT: Help with an SQL query on the AR System database...

2015-05-15 Thread Jarl Grøneng
Hi This subquery will list all the fields from all the forms You need to include the schemaid (A.FIELDID in (select B.FIELDID from FIELD_CHAR B where B.MAXLENGTH = 0 or B .MAXLENGTH = 1000)) -- J 2015-05-15 19:13 GMT+02:00 Joe D'Souza jdso...@shyle.net: ** I have developed this query

Re: Best and well behaved 8.x ARServer relese

2015-05-15 Thread Del Wester
Correct, ITSM is installed and actively using Incident, Change Problem with heavy customizations and a fully customized front end for non-Service Desk users. On Thu, May 14, 2015 at 1:08 AM, Jason Miller jason.mil...@gmail.com wrote: ** This sounds more like an ITSM system? On May 13, 2015