BMC ARSystem Remedy

20141004
----------------------------------------------------------------------

------------------------------------------
* Useful remedy tools
------------------------------------------
http://remedylegacy.com/tools/
http://soleauthority.net/  -- there are many examples, cool ***
http://missingpiecessoftware.com/
https://communities.bmc.com/community/bmcdn/bmc_atrium_and_foundation_technologies/bmc_remedy_ar_system/content?filterID=contentstatus[published]~objecttype~objecttype[idea]
Birt Reports: Resources -- https://communities.bmc.com/docs/DOC-32513
https://communities.bmc.com/docs/DOC-11739

------------------------------------------
* Web services
------------------------------------------
- Access Remedy the RESTful way
http://spf13.com/post/soap-vs-rest/
https://communities.bmc.com/docs/DOC-29073

------------------------------------------
* Great Idea's
------------------------------------------
Mid-Tier v8.1 with ARServer v7.6.04
https://communities.bmc.com/groups/product-ideas
Custom Android App for Field Engineers  -- https://communities.bmc.com/docs/DOC-31524
rMobility….a simple mobile solution where any end user can submit a BMC Remedy request, update, check status and approve via any mobile device -- http://www.raptek.com/rmobility/
Attachments in a Separate Form  -- https://communities.bmc.com/docs/DOC-82
Overlays - use of it for disable some al if-then-else -- https://communities.bmc.com/ideas/1407

------------------------------------------
* Mid-Tier
------------------------------------------
- cache
ehcache-core-2.0.1.jar
http://ehcache.org/         -- cacheMgr = CacheManager.create("...\\config\\ehcache.xml");
http://www.javablog.fr/javaehcache-a-simple-example-of-use-of-ehcache-2-6-2.html

- The Pulse: Mid-Tier Health Check based on Access logs
https://communities.bmc.com/community/bmcdn/bmc_atrium_and_foundation_technologies/bmc_remedy_ar_system/blog/2014/08/05/the-pulse-mid-tier-health-check-based-on-access-logs
https://communities.bmc.com/docs/DOC-32461

- Midtier doubt, 2 midtiers one for webservices, another for users
https://communities.bmc.com/thread/116288

------------------------------------------
* Useful links
------------------------------------------
https://docs.bmc.com/docs/display/public/itsm80/PDFs
http://www.bmc.com/blogs/
http://www.mail-archive.com/[email protected]/
http://ars-action-request-system.1.n7.nabble.com/

------------------------------------------
* ARSystem Server
------------------------------------------
- ar.conf
Yes, the Max-Log-History parameter works with the Max-Log-Size parameter to store versions of files (up to 999 I believe) for server side logs listed on the Server Information form -> Log File tab.
see algo logrotate unix command - http://www.thegeekstuff.com/2010/07/logrotate-examples/
<Default-Order-By: T>

Hidden and Undocumented Configuration Settings - https://communities.bmc.com/docs/DOC-20894

- debug
Workflow debugger - The AR System Workflow Debugger is a command-line utility that enables AR System application developers to debug workflow interactively.
183985-Opt-Tshoot-7604.pdf (p/84)

- https://communities.bmc.com/ideas/3542
Field Type - Field ID
Here is our scheme:
Range Type  Starting    Ending  # of Fields
Dynamic Group Fields    60001   N/A
Data Fields (Saved) 600010001   600016999   6998
Shared Data Fields (Saved)  600017001   600018999   1998
Temp Fields (Display Only)  600019001   600019699   698
Shared Temp Fields (Display Only)   600019701   600019999   298
Trim/page/button/column 600020001   600026999   6998
Shared Buttons Trim/page/button/column  600027001   600029999                   2998

- more fieldid -- Field ID Best Practices
https://communities.bmc.com/docs/DOC-16775

- Plug-Ins
https://communities.bmc.com/ideas/2137
http://docs.bmc.com/docs/display/ars81/Creating+plug-ins+to+extend+BMC+Remedy+Developer+Studio
c:\BMC\client\ARDevelop\DeveloperStudio\files\SamplePlugins-win32.win32.x86.zip\

------------------------------------------
* FAQ
------------------------------------------
- AREA LDAP vs ARDBC LDAP -- http://jxplorer.org/

AREA LDAP is for authentication - it allows you to use an LDAP server to verify the passwords of your users - an Active Directory   system for example.

ARDBC LDAP allows you to present information from an LDAP server in a Remedy form.  For example you could create a form listing all of the users in your corporate domain from an Active Directory server running LDAP.

- how to decrypt the current password field alone
You can't because the user passwords are encrypted using a one-way hash - they can't be decrypted.  You can use the PROCESS command Application-Confirm-Password to validate a string provided by the user against the current password.

- How discover client's IP or hostname? -- https://communities.bmc.com/thread/23268

------------------------------------------
* Logging
------------------------------------------
- web services
By default the Web Services plugin in 7604 uses the Java plugin server, not the C one as in previous versions. You need to edit the log4j_pluginsvr.xml file in the pluginsvr directory and set the log level for the plugin.  You'll need to add something like this
<logger name="com.bmc.arsys.ws.plugin.WSPlugin">
<level  value="debug" />
</logger>
Then you should see the SOAP data logged in the arjavaplugin.log file.

- Disable Email Engine Logging to Form
https://communities.bmc.com/ideas/1758
https://communities.bmc.com/docs/DOC-22528

------------------------------------------
* SQL
------------------------------------------
- Remedy Regular Form Record Counts
select a.schemaid,
       a.name,
       (select ut.num_rows from user_tables ut where ut.table_name = 't' || a.schemaid) t_rows,
       (select ut.num_rows from user_tables ut where ut.table_name = 'h' || a.schemaid) h_rows,
       (select ut.num_rows from user_tables ut where ut.table_name = 'b' || a.schemaid) b_rows
  from arschema a
 where a.schematype = 1
   and schemaid = 299