How to Delete a Container in BBNA

BCAN Utility Command:-

container-util.bat -url <url of bbna> -user <username> -password <password> -operation deprovision_container -containerName <name of the container to be deleted> -deleteonFailureFlag true

How to generate keystore in Tomcat

Sometime back, i was working for a customer, wherein implementing ASSO for CLM. During that time, i found and recorded the below commands for generating certificate using keystore in Tomcat.

Below are the commands used to generate keystore and certificate.

Command to generate keystore :-

keytool -genkey -alias <aliasname> -keyalg RSA -sigalg SHA1withRSA -keysize <Keysize = 1024 or 2048> -keystore <KeystorePathwith.p12 extn> -storepass <storepassword> -ext SAN=URI:<https://<SSO1ofFQDN>,SAN=URI:<https://<SSO2ofFQDN> -storetype PKCS12 -providername JsafeJCE

here storetype & provider name differs based on the Java version present in the system

Export the certificate(.cer) from keystore :-

keytool -export -storepass <changeit > -file <Pathtocertificate>.cer -keystore <pathtokeystore>

Import the certificate in to keystore :-

keytool -importcert -alias <ASSOFQDN> -keystore <conf dirofTomcat> -storepass <changeit> -file <path2certificate> -storetype PKCS12 -providername JsafeJCE

I am back after a long break

Its been an year since I posted in the blog, as I was busy with a complex implementation of Cloud to an enterprise customer. I will try to post few experiences, that I have faced during this time in the coming days along with my regular posts on other areas as well.....

Threads in BMC AR System

Today, we can see a brief info about threads

Threads:

1. Individual data channels between the AR Server and the database
2. Each designed for a specific function
3. Certain functions are more efficient with a properly structured thread.

At the server:

Depending on query type the server chooses which data channel; a backup of any due to channel limits can cause server lag.

Thread Types and usage:

• Fast –used for efficient queries
• List –Used for large data transfers
• Admin –used for Administrative functions
• Private –Individual dedicated threads

About AR System Forms in Database

How to go about a list of forms/fields in Database

In order to do this, you need direct SQL Access:

To get the schemaid for a particular form:

• Select schemaid from arschema where name=‘HPD:HelpDesk’

To get a list of forms and corresponding “T” tables:

• Select name,schemaid from arschema order by name

To get a list of all fields for a schema (e.g., schema 120):

• Select fieldname,fielded from field where schemaid=120

To get a list of all forms and fields:

• Select arschema.name,field.fieldname,field.fieldidfrom arschema,fieldwhere (arschema.schemaid=field.schemaid) order by arschema.name,field.fieldname

Please note that this is a brief note and you can go through the bmc docs for in-depth info about this topic.

Submitter Mode in BMC ITSM

Today, we can see about 'Submitter' Mode in BMC AR System

Submitter Mode:

Two Options:

 Locked: The value of ‘Submitter’ can never change

Changeable: ‘Submitter’ can change

Its Use:

• Ability for the submitter to edit ticket/data they submitted, both in and out of the BMC Remedy applications
• Development workflow that has been designed to accommodate your choice

Please note that this is a brief note and you can go through the bmc docs for in-depth info about this topic.

Discuss about 112 field - Assignee Group

Today I am going to brief about '112' field in BMC AR System

Field 112: The “Assignee Group” Field

                                                         Used to enforce row level permissions

                                                          BMC Remedy permissions are cumulative

                             If “Public”is ever in field 112 everyone will be able to see it

To enforce row level permissions all that is needed is:

                                                               i.      –Add field 112 to a form

                                                             ii.      –Add workflow to push the Group ID of any group that should have access

Please note that this is a brief note and you can go through the bmc docs for in-depth info about this topic.