Re: ITSM 7.6.04 Custom User SQL Logging

2012-05-15 Thread Gudat, Patrick
Your best bet would be to just enable the sql log and then use a log parsing tool to pull out the interesting bits. No need to get fancy. I would think that tracking admin activities would be just as important as non admin ones. Patrick On 5/15/12 9:33 AM, "Phil" wrote: >Hi, > >We have a requ

ARSmarts 2.8.0 now released

2012-05-15 Thread Support
Hello List, We are happy to let you know that version 2.8.0 of ARSmarts in now released. We would like to thank all the folks who participated to the beta program and provided very valuable feedback. Thanks to their time, we were able to make ARSmarts even more useful. ARSmarts 2.8.0 takes

Re: how to get the values instead of ID's in the Database table

2012-05-15 Thread ravi rai
Sagar, you can create SQL join and pull details from the menu defination if it is only for reporting needs You can also save the value in the DB what is shown to user insted of saving ID of the selected menu. check 'Value Field' and 'Label Field' in menu. you might have to chage data type of

Re: ITSM 7.6.04 - ARS 7.6.04.03 - Reported Date vs Submitted Date

2012-05-15 Thread patchsk
In the new ITSM, Reported Date gets populated when the agent enters the customer information on the incident create screen. So the difference between Reported Date and Submit Date is really the amount of time the agent took to log the ticket. Other than that we did not see much difference or use

Re: ITSM 7.6.04 - ARS 7.6.04.03 - Reported Date vs Submitted Date

2012-05-15 Thread Sanford, Claire
In the old (I miss it so very much) Help Desk 6.0 you could tell the system to "start the clock" on Submit. I can't seem to find this setting in the new ITSM. I have looked in the Incident Rules section and there is no choice there. The problem we are running into is that sometimes a ticket si

JOB: Remedy Developer DC - Must have TS Clearance

2012-05-15 Thread Brian Pancia
We are still looking for a Remedy developer with a TS Clearance to join our team. We are looking for a developer with 3-5 years' experience that will assist a Senior Developer in upgrading ITSM 7.6.03 to either 7.6.04 or 7.7 when it is released. In addition, this is a great opportunity for a mid-

Re: ITSM 7.6.04 - ARS 7.6.04.03 $\TIME$

2012-05-15 Thread Sanford, Claire
I figured out the problem. I needed to have this set in a character field, not a "Time" field. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wirasat Siddiqi Sent: Monday, May 14, 2012 3:24 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7.6.04 - ARS

Re: Adding HR Department to ITSM Application using Multi-tenancy

2012-05-15 Thread Poston, Lynn
Thanks for the input Brian. I appreciate it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia Sent: Tuesday, May 15, 2012 10:44 AM To: arslist@ARSLIST.ORG Subject: Re: Adding HR Department to ITSM Application using Multi-tenancy ** You

Re: Adding HR Department to ITSM Application using Multi-tenancy

2012-05-15 Thread Brian Pancia
You can setup: Company 1 - Allpeople Company 2 - IT Support Company 3 - HR Then setup company 2 & 3 to support company 1. This will give company 2 & 3 access to company 1. The problem will come with the data segregation part. On your Incident form field 6969 and 112 will setup your perm

ITSM 7.6.04 Custom User SQL Logging

2012-05-15 Thread Phil
Hi, We have a requirement to track all user activity including all the searches a user performs. I could just enable the SQL log to write to a form but this will also include all the admin actions, AR Escalator etc. Has anyone created a custom SQL log which only includes the user details and wri

Re: Want to implement Single Sign-On(SSO)

2012-05-15 Thread Brian Pancia
John Didn't state single user repository just authentication repository. SSO will allow you to setup multiple repositories (LDAP, RSA, CAC, Local, etc.). That's why my original question was what exactly is SSO going to be used for. If it is to provide LDAP capabilities for Mid-tier then there ar

Adding HR Department to ITSM Application using Multi-tenancy

2012-05-15 Thread Poston, Lynn
ARS 7.6.04 SP3 & ITSM 7.6.04 SP2 We use ITSM for our IT support personnel and for our field users (SRM). We also have a custom app that we created using remedy that our HR Department and employees use on another server. What we are wanting to do is add the HR group to our ITSM app but keep th

Re: how to get the values instead of ID's in the Database table

2012-05-15 Thread Goodall, Andrew C
-- here's something I use in an SSRS report to pull based on prompt for schema keyword. SELECT [name],[schemaid] from [dbo].arschema where [name] like '%' + @schemasearch + '%' order by [name]; SELECT [fieldname],[fieldid] FROM [dbo].[field] where [schemaId] = @schemaname and [dataType] = 6 an

Re: Want to implement Single Sign-On(SSO)

2012-05-15 Thread Pat Zandi
Can I ask what is your plan or method for doing it? Like do you need CAC? Certs, or just AD authentication? Do you require secure methods? 686 vice 389 (or what ever)? Just wondering Sent from my iPhone On May 15, 2012, at 2:51, John Baker wrote: > Brian > > Ref: Single user repository

Re: how to get the values instead of ID's in the Database table

2012-05-15 Thread vidyasagar kommu
Hi Ann, In the main form i have filed "A" this field A is dependent on prooduct and producttype value when the user select product and product type value so i need to pass the product and product type dynamic values to another form i.e regular form for getting the Field A value for this approach

Re: how to get the values instead of ID's in the Database table

2012-05-15 Thread Ann Ctl
Can you give an example of the field I. The main form, the field on the other form and what you are seeing. Also when you say mapped what do you mean? Thanks Ann Sent from my iPhone On 15 May 2012, at 11:24, vidyasagar kommu wrote: > Hi All, > > I have 1 Mainform and 3 other regular form

how to get the values instead of ID's in the Database table

2012-05-15 Thread vidyasagar kommu
Hi All, I have 1 Mainform and 3 other regular forms mapped with the fields of Main form respectively on the basis request id of other regular form. The mapped fields have menus attached to it. I can see the values properly in the Main form. But in the Database of Main form I am unable to see the