Re: MyIT/SmartIT First Impressions
Below are a few items that I'm not pleased with on Smart IT: Assignment Menu only displays support group names and only those that are within your company. I've created an idea on BMC Communities to enhance this: https://communities.bmc.com/ideas/9444 Permission Dependency - Right now you have to have certain permissions in order to even log into Smart IT. One of those permissions is Contact People User which we do not give out to many people. I would rather see it allow all users to log in, but only show the functionality that there permissions allows them to see. This is how the current ITSM works. I've also submitted the following idea for this: https://communities.bmc.com/ideas/9445 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: BMC Remedy Attachments
Hi Mark, from your message this is through Java. Would you happen to know if this would work over a DB Link where we transfer the Blob file using it? Because from my experience it gets corrupted when the blob is transferred. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Active Directory Integration
Hi, Environment: 8.1 x Oracle 11 R2. We are trying to integrate AD with Remedy to update our people profiles. Our challenge is that the data in AD is messed up. Approximately how long does it take to typically integrate AD and Remedy (when there are data problems)? (from the concept until completion). We have a couple of options: create vendor forms create staging form create escalation from push AD to Vendor, and from the Vendor to Staging OR should I used UDM? or pre-defined LDAP jobs use DMT staging form - to validate LDAP filters Which approach is better is better? and what are some of the advantages / disadvantages? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: CI Relationships
There is really no easy way to do it, even with Analyitics. I am working on SQL
to do something very similar. My customer wants to see the relationships on the
same line as well. I wrote the SQL and am using it in BMC Analytics with Custom
SQL for the report. This code was written for SQL Server 2012 and this is based
on the Views from CMDB 8.1. The key to this is the distinct statment at the
begining and the (Select Top1 from AST_AssetPeople.Full_Name) and join to
AST_AssetPeople. I am also looking for any related OS records that were
discovered for the asset. You will have to tweak this to account for your own
Product catalog. I am also joining to AST Attributes for some custom fields,
but I don't have them in this statement.
I hope this helps,
Jesus Ortega
SELECT Distinct
AM_BMC_CORE_BMC_BASEELEMENT.Name ,
ISNULL(AM_BMC_CORE_BMC_BASEELEMENT.AssetID,'UNKNOWN') 'Asset ID',
AssetLifecycleStatus.ASSETLIFECYCLESTATUS,
-- AM_BMC_CORE_BMC_BASEELEMENT.InstanceId ,
AM_BMC_CORE_BMC_BASEELEMENT.Region ,
AM_BMC_CORE_BMC_BASEELEMENT.SiteGroup,
ISNULL(AM_BMC_CORE_BMC_BASEELEMENT.Floor,'UNKNOWN') as 'Floor',
ISNULL(AM_BMC_CORE_BMC_BASEELEMENT.Room,'UNKNOWN') 'Room' ,
(
Select Top 1
AST_AssetPeople.Full_Name
FROM
AST_AssetPeople
Where
AST_AssetPeople.AssetInstanceId=
AM_BMC_CORE_BMC_BASEELEMENT.ReconciliationIdentity
AND
( AST_AssetPeople.PersonRole )=39000
)as 'Managed by',
(
Select Top 1
AST_AssetPeople.Full_Name
FROM
AST_AssetPeople
Where
AST_AssetPeople.AssetInstanceId=
AM_BMC_CORE_BMC_BASEELEMENT.ReconciliationIdentity
AND
( AST_AssetPeople.PersonRole )=1
) as 'Supported by' ,
AM_RELATED_CI.Name 'OS',
AM_BMC_CORE_BMC_BASEELEMENT.Description as 'Comments'
,
ISNULL(AM_BMC_CORE_BMC_BASEELEMENT.SerialNumber,'UNKNOWN') as 'Serial No.'
FROM
AST_AssetPeople RIGHT OUTER JOIN (
SELECT *
FROM BMC_CORE_BMC_BASEELEMENT
WHERE BMC_CORE_BMC_BASEELEMENT.COMPANY = 'your company here'
) AM_BMC_CORE_BMC_BASEELEMENT ON (AST_AssetPeople.AssetInstanceId=
AM_BMC_CORE_BMC_BASEELEMENT.ReconciliationIdentity)
LEFT OUTER JOIN (
SELECT FIELD_ENUM_VALUES.ENUMID,
FIELD_ENUM_VALUES.VALUE AS ASSETLIFECYCLESTATUS
FROM FIELD_ENUM_VALUES
WHERE FIELD_ENUM_VALUES.FIELDID = 7
AND FIELD_ENUM_VALUES.SCHEMAID = (SELECT SCHEMAID
FROM ARSCHEMA
WHERE NAME =
'BMC.CORE:BMC_BaseElement') )
AssetLifecycleStatus ON
(AssetLifecycleStatus.ENUMID=AM_BMC_CORE_BMC_BASEELEMENT.AssetLifecycleStatus)
LEFT OUTER JOIN BMC_CORE_BMC_BASERELATIONSHIP AM_BMC_BASERELATIONSHIP ON
(AM_BMC_CORE_BMC_BASEELEMENT.InstanceId=AM_BMC_BASERELATIONSHIP.Source_InstanceId
and AM_BMC_BASERELATIONSHIP.Name IN ('SYSTEMOS'))
LEFT OUTER JOIN (
SELECT *
FROMBMC_CORE_BMC_BASEELEMENT
WHERE BMC_CORE_BMC_BASEELEMENT.COMPANY ='You company here'
)
AM_RELATED_CI ON
(AM_BMC_BASERELATIONSHIP.Destination_InstanceId=AM_RELATED_CI.InstanceId )
-- AND AM_RELATED_CI.Item = 'Operating System and Components'
LEFT OUTER JOIN AST_Attributes ON
(AST_Attributes.ReconciliationIdentity=AM_BMC_CORE_BMC_BASEELEMENT.ReconciliationIdentity)
WHERE
(
( ( ISNULL(AM_BMC_CORE_BMC_BASEELEMENT.Category,'UNKNOWN') ) = 'Hardware' )
AND
AssetLifecycleStatus.ASSETLIFECYCLESTATUS NOT IN (
'Delete','Disposed','End of Life' )
AND AM_BMC_CORE_BMC_BASEELEMENT.datasetid = 'BMC.ASSET'
AND
AM_BMC_CORE_BMC_BASEELEMENT.Item IN ( 'Server' )
AND AM_RELATED_CI.Name is not null)
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Re: Active Directory Integration
Koyb, How long is a string? It is difficult or impossible to answer your question. You state, data in AD is messed up - I assume you got very poor data quality, no naming standard, lack of phone number standard, use of incorrect fields, no good unique identifier, no standard for department names and more. There is nothing like a typical integration every project is different. Are you going to have a one way feed? What about leaver? Are you going to automate the leavers' process? Who or what if feeding AD? Created manually? Integrated with different HR systems? Who owns the AD data? How is responsible for maintenance of AD? Is it maintained? If AD is the source of People data in BMC - please do not forget: shit in shit out! Creating staging forms and more within BMC is good and well. Most of us have done that a number of times. My first advice would be to clean the data at source. AD is more likely feeding a number of systems. I would recommend a AD cleanup project. That will benefit a larger audience. ~ Terje From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Koyb P. Liabt Sent: Thursday, March 05, 2015 5:03 PM To: arslist@ARSLIST.ORG Subject: Active Directory Integration ** Hi, Environment: 8.1 x Oracle 11 R2. We are trying to integrate AD with Remedy to update our people profiles. Our challenge is that the data in AD is messed up. Approximately how long does it take to typically integrate AD and Remedy (when there are data problems)? (from the concept until completion). We have a couple of options: create vendor forms create staging form create escalation from push AD to Vendor, and from the Vendor to Staging OR should I used UDM? or pre-defined LDAP jobs use DMT staging form - to validate LDAP filters Which approach is better is better? and what are some of the advantages / disadvantages? _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: The ~! for filter names
Guys this was a suggestion only.. [?][?] Yes having some property will also be fine, but there should be something from which we can identify that filter is an overridden filter. Regards, Harsh On Thu, Mar 5, 2015 at 3:00 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, The suffix solution seems very dirty to me. A quick fix most likely, as it did not need GUI changes. It would be easy to do a conversion during upgrade, or a tool to add the property to any FLTR with the suffix. You can add properties as columns in DevStudio, so it could still be visible when reviewing you filter list. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Harsh, I agree with Fred Rick, it makes more sense to rather have it as a property rather than only as some text appended to the name, but you would need to have BMC automate keeping both conventions going to make it backward compatible with existing workflow. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: 03 March 2015 18:56 To: arslist@ARSLIST.ORG Subject: Re: The ~! for filter names ** Harsh- You would still have the option of using that naming convention to indicate the phasing but I think it makes more sense to make it a property of the filter rather than relying on the filter name to trigger the phasing. There’s no reason we can’t set the phasing in a filter property and also append `! to the name (or whatever other naming syntax you wish, there might be something else that makes more sense). -Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Harsh Sent: Monday, March 02, 2015 7:31 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: The ~! for filter names ** Yes, it is there `! , and i don't think it would be better to remove `!, as a developer i am not at all wishing to open each filter and check if it is overriding the filter phasing. Better i can guess from its name. Regards, Harsh On Tue, Mar 3, 2015 at 4:04 AM, Grooms, Frederick W frederick.w.gro...@xo.com mailto:frederick.w.gro...@xo.com wrote: The 2 are not exactly the same. The release pending causes the Phase 2 actions to happen, then comes back to this Filter. The `! causes this filter to run in Phase 1 I put an idea out in the Developer Communities to change needing `! https://communities.bmc.com/ideas/3639 Vote it up ;) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Joe D'Souza Sent: Monday, March 02, 2015 4:20 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: The ~! for filter names Still there as far as I know as well. They have an additional PROCESS action though that was added somewhere around AR System 6.3 days that mimics that so that the code is not dependant on the name of the Filter. The action is RELEASE-APPLICATION-PENDING. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Mitcham, Ross Sent: Monday, March 02, 2015 1:24 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: The ~! for filter names It should still be there, but it is `! not ~! (not sure if this is a typo) Regards, Ross Mitcham Lead Product Developer Direct +1 905.707.3534 tel:%2B1%20905.707.3534 50 Minthorn Bvld. Suite 200 Markham, ON L3T 7X8 Canada -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Ray Gellenbeck Sent: Monday, March 02, 2015 1:14 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: The ~! for filter names Was the ~! function deprecated out in 8.x? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org Where the Answers Are, and have been for 20 years -- Thanks regards “Harsh Chaudhary” Impatience never commanded success _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access
Re: The ~! for filter names
Hi, The suffix solution seems very dirty to me. A quick fix most likely, as it did not need GUI changes. It would be easy to do a conversion during upgrade, or a tool to add the property to any FLTR with the suffix. You can add properties as columns in DevStudio, so it could still be visible when reviewing you filter list. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Harsh, I agree with Fred Rick, it makes more sense to rather have it as a property rather than only as some text appended to the name, but you would need to have BMC automate keeping both conventions going to make it backward compatible with existing workflow. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: 03 March 2015 18:56 To: arslist@ARSLIST.ORG Subject: Re: The ~! for filter names ** Harsh- You would still have the option of using that naming convention to indicate the phasing but I think it makes more sense to make it a property of the filter rather than relying on the filter name to trigger the phasing. There’s no reason we can’t set the phasing in a filter property and also append `! to the name (or whatever other naming syntax you wish, there might be something else that makes more sense). -Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Harsh Sent: Monday, March 02, 2015 7:31 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: The ~! for filter names ** Yes, it is there `! , and i don't think it would be better to remove `!, as a developer i am not at all wishing to open each filter and check if it is overriding the filter phasing. Better i can guess from its name. Regards, Harsh On Tue, Mar 3, 2015 at 4:04 AM, Grooms, Frederick W frederick.w.gro...@xo.com mailto:frederick.w.gro...@xo.com wrote: The 2 are not exactly the same. The release pending causes the Phase 2 actions to happen, then comes back to this Filter. The `! causes this filter to run in Phase 1 I put an idea out in the Developer Communities to change needing `! https://communities.bmc.com/ideas/3639 Vote it up ;) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Joe D'Souza Sent: Monday, March 02, 2015 4:20 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: The ~! for filter names Still there as far as I know as well. They have an additional PROCESS action though that was added somewhere around AR System 6.3 days that mimics that so that the code is not dependant on the name of the Filter. The action is RELEASE-APPLICATION-PENDING. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Mitcham, Ross Sent: Monday, March 02, 2015 1:24 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: The ~! for filter names It should still be there, but it is `! not ~! (not sure if this is a typo) Regards, Ross Mitcham Lead Product Developer Direct +1 905.707.3534 tel:%2B1%20905.707.3534 50 Minthorn Bvld. Suite 200 Markham, ON L3T 7X8 Canada -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Ray Gellenbeck Sent: Monday, March 02, 2015 1:14 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: The ~! for filter names Was the ~! function deprecated out in 8.x? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org Where the Answers Are, and have been for 20 years -- Thanks regards “Harsh Chaudhary” Impatience never commanded success _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: BMC Remedy Attachments
Meta-Update uses the API and can transfer attachments by reference (or indeed to/from the file system). It can also change file names etc. No staging forms or workflow is needed. Here’s a sample script: Query = Src, ATT:AttachmentTable, '1' = $Arg, src$ Update = Tgt, ATT2:AnotherTable, 'Old1' = $Arg, src$ Assign = asg-sec [asg-sec] AttField1 = Src, AttFieldSrc Cheers, Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email:mailto:ben.cher...@softwaretoolhouse.com ben.cher...@softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as the tree of data and forms that it is it is. Pre ITSM 7.6.04? Clarify? Roll your own? No problem! You can keep your valuable data! http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Allan See Sent: March-05-15 00:19 To: arslist@ARSLIST.ORG Subject: BMC Remedy Attachments Hi, I need help in understanding what Remedy uses as compression for File Attachments when inserting it to our B tables. Also does anyone know how we can migrate attachments to another table over a DB link. I have recently tried to do this but files that are migrated gets corrupted. thank you, TIA ___ UNSUBSCRIBE or access ARSlist Archives at http://www.arslist.org www.arslist.org Where the Answers Are, and have been for 20 years - No virus found in this message. Checked by AVG - http://www.avg.com www.avg.com Version: 2015.0.5645 / Virus Database: 4299/9228 - Release Date: 03/04/15 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years smime.p7s Description: S/MIME cryptographic signature
