Print Page   |   Contact Us   |   Sign In   |   Register


Join Vivit
Contact Vivit
Become a Leader
Become a Sponsor
Community Search
Calendar

9/28/2016
Vivit Minnesota ITSM Fall Chapter Event

9/28/2016
Become a Cloud Master with the HPE Helion Cloud Suite - Part 2

9/29/2016
Vivit Chicago Chapter Event

9/29/2016
How Secure Content Management Can Help Align Governance and Security

10/4/2016
PPM 9.40: How the New Features of HPE PPM can Help your PMO

LinkedInTwitterFacebookGoogle Plus

 
HPE Software Products: IT Asset Manager / Connect-IT Support and News Forum
Share |

how to import data from sharepoint to sqldb of array fieldsOpen in a New Window

Hi All,

I have source as sharepoint list and destination as sqldb.

my requirement is push the data from sahrepoint to sqldb through connecti it.

I have two problems and need solution.

1. How to auto refresh the my msaccess db file which is linked to sharepoint and acting as source connector?

2. I have records in my in sharepoint as follows.

Column1 Column2 Column3
A123 abc abc123
A123 xyz xyz345
A123 pqr pqr485


And i have the fields in my destination as dbfield1, dbfield2, dbfield3......

Here dbfield2, dbfield3 are array type fields in sqldb and dbfield1 is primary key.

Any now my requirement is to map the data as

Column1 <-> dbfield1

Column2 <-> dbfield2

Column3 <-> dbfield3

As i said here dbfield2 and dbfield3 are array fields once i map the data as mentioned above 3 rows of data from source should be moving to destination sqldb with only 1 row as dbfield1 is primary key.

But i ahve a challenge in acheiving this, please can any one help on my requirement who is familier with connect-it as i am new to this.

Thanks in advance.

Regards,

D_M_K

 

status transition in HP Asset managerOpen in a New Window

hi team,

 

please let me know how to configure status transitions in AM 

Suppose if any asset status is IN use then again the status should not be in use before changing the status to In stock. Means new status shouldnot be same as old status

2) then if any status of asset is Lost or retired then status of that Asset should not be changed to In USe.

 

 

 

 

 

 

 

SAP integration with HPAM consuming webservices of SAPOpen in a New Window

Hi team,

We are trying to send PO from SAP in HPAM so we are using SAP webservices connector. but while consuming it we can see different different tables on SAP web services end but Produce button is not enabled. Please suggest something.

Regards

 

Reports Web ClientOpen in a New Window

Hi, we use AM 9.50 and in the windows client we can see Reports menu but in web client we can´t see Reports menu it is normal or i need to do a extra configuration

 

 

 

Mandatory and IrrelevanceOpen in a New Window

Pls help

 

I have user field where I want when Status of an Asset is In Use then USEr field should become mandatory. And when status is not equal to In use then this field should be hidden and not popped up in the screen. I tried a lot with different scripts but its not working.

 

Assign an Asset to a groupOpen in a New Window

Assignemnt of an Asset To a Group

hi team,

 

please let me know how to assign an asset to  a Group of members.

 

supoose server is there it belongs to system team and in system team five members are there so how to assign that asset to a group so anyone of member can work on that asset

thanks

 

October 10-11th: Asset Manager Expert Day!Open in a New Window

Asset Management is hosting an Online Expert Day on Oct 10th - 11th:, 2016!  Mark this on your calendars!Asset Management is hosting an Online Expert Day on Oct 10th - 11th:, 2016! Mark this on your calendars!

Hello Everyone,

 IT Asset Manager is hosting an Online Expert Day on October 10-11th, 2016!  Mark this on your calendars!

 If you are a customer with a support contract, then we would like to invite you to join us in IT Asset Manager Support Customer Forum on October 10-11th when HPE product Experts will be online for 24 hours to answer any questions regarding " Any Topic"

  

What is an Online Expert Day?

 Online Expert Day is an event when HPE product, R&D, and Support team members and other employees join our online forums to answer your toughest technical questions.  Online Expert Days give you a chance to talk directly with the HPE Experts!

 

How does the Online Expert Day event work?

 Starting on October 10th at 8.00 AM Pacific Daylight Time / 11:00 AM Eastern Daylight Time / 3 PM Greenwich Mean Time, log in to the IT Asset Manager Support Customer Forum and create new posts to ask your questions. 

 

The Online Expert Day will end on October 11th at 8.00 AM Pacific Daylight Time / 11:00 AM Eastern Daylight Time / 3 PM Greenwich Mean Time.

 HPE Experts will be online for 24 hours in the forum and will do their best to answer your questions. They may need to get some more information from you so please check the box "email me when someone replies".  An online conversation will be born!

 To participate, you do need access to the IT Asset Manager Support Customer Forum.  If you don’t have access, please add your Support Agreement ID (SAID) to your HPE Passport profile and log in again.

 If you have a valid support contract and are still experiencing issues, please send an email to swcommunity@hp.com.

 For more information on our Support Customer Forums and how to add your Support Agreement ID (SAID) to your HPE Passport profile, please click here.

 For upcoming Online Expert Days, please bookmark the HPE Software Online Support Services - Forum events page.

 If you have questions regarding the Online Expert Day event, please reply to this message.

 We look forward to your attendance and your questions!

Regards,

HPE Software Support

 

AM 9.5 Workflow (-53) ErrorOpen in a New Window

Here is my issue experts.  I have two workflows that monitor the amInputEvent table for record inserts and record updates. 

 First workflow: Works fine , except for error when I activate the second workflow

2016/09/15 16:49:1.517        0        4        Executing workflow rules for execution group 'HMCB'...

2016/09/15 16:49:1.580        1        1        (-53) Error executing action from activity 'HMCB Create OutEvent' in workflow 'HMCB SM Event'.

2016/09/15 16:49:1.580        1        1        (-53) Unable to complete operation in current state.

  Second workflow:   When I test the script it runs just fine, but the workflow gives the error.

 HMCB Create EventOut script:


Dim hrOut, lErr, lOutputEventId as Long
Dim reqUUID as String

reqUUID = [EventNo]
lOutputEventId = AmDbGetLong("Select lOutputEventId From amOutputEvent Where EventNo='" & reqUUID & "'")

If lOutputEventId = 0 Then
If [seStatus] = 2 Then

'*** Create SM Approval Event Out
hrOut = AmCreateRecord("amOutputEvent")
lErr = AmSetFieldStrValue (hrOut,"EventNo",reqUUID)
lErr = AmSetFieldStrValue (hrOut,"Category", "HMCB SM")
lErr = AmSetFieldLongValue(hrOut,"seStatus",0)
lErr = AmSetFieldStrValue (hrOut,"ResCode", "Approved")
lErr = AmSetFieldStrValue (hrOut,"memMessage", "Budget is available")
lErr = AmInsertRecord(hrOut)
lErr = AmReleaseHandle(hrOut)

ElseIf [seStatus] = 3 Then

'*** Create SM Denial Event Out
hrOut = AmCreateRecord("amOutputEvent")
lErr = AmSetFieldStrValue (hrOut,"EventNo",reqUUID)
lErr = AmSetFieldStrValue (hrOut,"Category", "HMCB SM")
lErr = AmSetFieldLongValue(hrOut,"seStatus",0)
lErr = AmSetFieldStrValue (hrOut,"ResCode", "Denied")
lErr = AmSetFieldStrValue (hrOut,"FailureReason", "Not Enough Budget")
lErr = AmInsertRecord(hrOut)
lErr = AmReleaseHandle(hrOut)

End If

 

How to... Flag Software Installations that require a purchased licenseOpen in a New Window

Is there a function/field in UD / HPAM that identifies a software installation requiring a license purchased from the manufacturer?

Example: Where Adobe Acrobat Pro installation requires a purchased license and Adobe Acrobat Reader does not, can UD / HPAM flag the Acrobat Pro installation automatically?

Requirement: Reduce the amount of re-occurring manual labor required to identify the 10's of thousands of applications discovered by UD that does not require a software license purchase to be installed. The objective is to be able to report on all application installations based on the 'Software installation' nature where 'amSoftInstall.bLicenseExcluding' is = No (License is NOT excluded from License calculation)

Can this be done without using a third part product?

 

 

Assignemnt of an Asset To a GroupOpen in a New Window

hi team,

 

please let me know how to assign an asset to  a Group of members.

 

supoose server is there it belongs to system team and in system team five members are there so how to assign that asset to a group so anyone of member can work on that asset

 

How to execute a workflow every dayOpen in a New Window

Hello Experts

I configure a couple workflows and I need execute them every day to keep information updated in contracts

How I can do that?

Thank you

Best regards

 

Asset Manager Server hostname changeOpen in a New Window

Hi Experts,

There is an issue with the customers network, therefore they need to change the HOSTNAME of Asset manager Application server. On this server Automated Process Manager, Business object server (crystal reports server) and Connect IT is running.

I wanted to understand what will be the impact on the AM components if the hostname is changed.

1.  APM and AM License

2. Business Object 4.1 Server (as it installed using the hostname)

3. Connect IT licenses

 

R's headstrong

 

HP Asset Manager - Default value - get current dateOpen in a New Window

In asset manager, how can i say the default valut of a field is the current day? Thanks in advance

 

AM powerpoint presentationsOpen in a New Window

Hi is anybody there that has som introductory powerpont (or pdf) presentations for am introduction to AM?

WHere can I find AM PPTs?

Thanks

Paolo

 

Need assistance in creating an AssetTag for a given PO Order once it has been receivedOpen in a New Window

Hi HP Team,

I need to create a Record (License Asset) in Asset table from Receipt lines table, once Purchase Order has been received. I am not sure, how to map Asset Tag field and how to apply Reconciliation properties to Asset table.

Please refer my mapping from the below screen shot.

I set Reconciliation Property of Asset Table to "Update or Insert".

As Asset Tag will be generated automatically, could please let us know do we need to map Asset Tag field in the scenario?

If no need to be mapped, which other mandatory fields need to be mapped inorder to create a new License Asset in Asset table?

Asset-Creation.jpg

Thanks much..!

With Regards,

Pawan24kart

 

UD and AM intergrationOpen in a New Window

Please help in below.

 

 

First Case:

Suppose we have an Asset with below details already present in HPAM. WE followed Procurement Cycle and created this asset.

serialnumber

model

Assettag

Type

Abcdefgh

HP Elite

LT001

Laptop

 

 

Now when UD discovers the same asset and has different model from the above one, it creates duplicate assets.

 

serial number

model

Assettag

Type

Abcdefgh

HP Elite Book

 

Laptop

 

 

Requirement is that there should not be any duplicate assets created. I tried below methods

 

  1. I deleted the record from HPAM and created it with different model and then pushed it, Job failed or sometimes it creates duplicate assets. Logged case with HP but there is no proper response. Did some changes in xml file but it didn’t work out.

 

Getting warning message while running check definition of the webservvicesOpen in a New Window

Please help i am getting the below warning message.Untitled.jpg

 

Error while opening web clientOpen in a New Window

Error.pngPlease help. PFA error while opening web client

 

 

[Thrd#:6284](0) The definition of the 'AcquContract/amContract|seType IN (0, 1, 2, 6)' screen does nOpen in a New Window

while running check definition of web services i am recieveing below error please help.,AM version is 9.50

 

[Thrd#:6284](0) The definition of the 'AcquContract/amContract|seType IN (0, 1, 2, 6)' screen does not exist in this database.

 

AM9.50 - Autofill of dAssignment fieldOpen in a New Window

Hello all,

Is there some sort of automatic mechanism that fills in the dAssignment field when the seAssignment field becomes In Use (or rather, 0 from the database point-of-view).

I have removed the Default script, but whenever changing the seAssignment value to 0, the dAssignment field is automatically filled in with today's date.

Is there a way to turn this off? The Automatic Software Mechanisms document don't seem to incidate that the dAssignment value changes when the seAssignment value becomes 0.

Thank you!






Sign In


Forgot your password?

Haven't registered yet?

Vivit Blog