Device activity (history) in SC6

[zzz01]

Hi,

I am implementing the configurations management module in ServiceCenter. Every device has a specific status (installed, available, wharehouse, retired...).

Now, in our company, the status of a device often changes. How can I keep the history of the different statuses of a device? I want something like the "activity" in incident management.

Thanks in advance.


-------------------------------------------------------
SC 6.1.1
P4 database
Windows 2003 Server SP1

[tommy]

In 6.1.x You can add acitivity to all files. Via database manager check the table "activityactions" look how they are made for the other files then copy one of them and amend it so it suits the device file.

You will need to create a new activity file for the devicetable for example "activitydevice" and then you also need to amend the forms and links. Look in incident management how that is done.

I havn't tries this yet but you should be able to get this to work.

[outlance]

You could give this one a try - I haven't tested it with Inventory Management/Configuration Management yet - please let me know, if it works...

Greets,

Lars

[zzz01]

Hi,

In "activityactions", I created a "Open Activities", "Update Activities" and "Close Activities" for the device file with the corresponding conditions.
I also created "activitydevice" file.

In device.computer.g, I added a subformat pointing to activitydevice.list (a format I created containing the information I need to show) with a virtual join (with logical.name.vj as an input). In the device link, I added two links to the activitydevice file (just like there are links between probsummary and activity files).
Now, when I change the status of a computer, nothing is shown in activitydevice.list form. Did I miss something?


Thanks.

[outlance]

did you check, if you have data in activitydevice table?

[zzz01]

did you check, if you have data in activitydevice table?

Yes I checked. I have no data in activitydevice table, and that's the problem. Maybe the "activityactions" I created do not work?

I'd appreciate if anyone can help me on this.

Thanks.

[glg]

You also need to define the activitydevice table, etc in the Object table. Pull up the device record and you set it on the Activities tab (look at the probsummary record for an example).

[outlance]

Yes I checked. I have no data in activitydevice table, and that's the problem. Maybe the "activityactions" I created do not work?

I'd appreciate if anyone can help me on this.

Thanks.

Did you follow each step of this description?

http://meintool.blogidoo.de/2005/12/...vicecenter-61/

Greets,

Lars

[tommy]

I couldn't remember if a trigger was required but I think thats what is missing.

[outlance]

I couldn't remember if a trigger was required but I think thats what is missing.

Add record in triggers table - you can copy one of the existing records like “activityservicemgt.pre.add”. Change “Trigger name” to “activitychange.pre.add” and change “Table Name” to “activitychange”. Add new trigger with “Add” - do not press “Save”



.... I mentioned it ...
Lars

[tommy]

.... I mentioned it ...
Lars

Yep I saw that. Thats why I mentioned it and why I originally did not suggest this as I wasn't sure and didn't have a sc6.1 up running at the moment.

[zzz01]

Did you follow each step of this description?

http://meintool.blogidoo.de/2005/12/...vicecenter-61/

Greets,

Lars

Thank you Lars for the link,

I followed every step in it:

1) dbdict "activitydevice" created
2) created "activitydevice" form with file name "activitydevice" (Note: in your link, the file name of "activitychange" is "cm3r". Is it rather "activitychange" file instead of "cm3r"?)
3) created "activitydevice" in number file
4) "activitydevice" in notebook tab "Activities" of device Object (Document Engine)
5) Added the following two actions: (in "activityaction"/device table)
1. Name:Open
Condition:$L.mode="add"
Description:{"Device " + logical.name in $L.file + "added"}

2. Name: Update Activities
Table: device
Mode: update
Condition: $L.mode="update"
Details:
Name: Change Status
Condition: not same(istatus in $L.file,istatus in $L.file.save)
Description: {"State of the device changed from" + istatus in $L.file.save + "to" + istatus in $L.file}

6) Added "activitydevice.pre.add" trigger in device table.

I also called the sc.activity application with the parameters you mentioned in the link (cm3r being replaced by device).


Now, when I change the status of a device, nothing is written to activitydevice table. It does not work.

Has anyone tested activity in "device" table? Did I miss something?

Thank you in advance for your help.

[rdaniel]

Hello.

I am trying to implement Activities as discribed in the atachment file.

I have done this exactly as in the file, using the exact same forms and processes, everything, and i am getting a lot of errors:

"
Unrecoverable error in application: apm.activity on panel check.activity.1
Unrecoverable error in application: se.call.process on panel call.rad.1
Cannot evaluate expression (sc.activity,check.activity.1)
Bad arg(2) oper in (sc.activity,check.activity.1)
Cannot evaluate expression (sc.activity,check.activity.1)
Bad arg(1) oper not (sc.activity,check.activity.1)
Cannot evaluate expression (sc.activity,check.activity.1)
Bad arg(2) oper and (sc.activity,check.activity.1)
Cannot evaluate (not null) (sc.activity,check.activity.1)
Cannot evaluate expression (sc.activity,check.activity.1)
Cannot evaluate expression (sc.activity,check.activity.1)
Bad arg(1) oper nullsub (sc.activity,check.activity.1)
Cannot evaluate expression (sc.activity,check.activity.1)"

Has someone tried this?

Can you help, please?

Thanx a lot

[jstagaman]

Well, the problem may be that when you update a computer device, for example, you aren't updating against the device table, but against joincomputer, the join of the computer attributes table and the device table.

You might need to call activity for each device type separately so that you can act against the join (though I'm not certain that you can configure activity against a join).

[rdaniel]

Thank you for the the help but after some time i got it to work!!

Hurray for me!!

I also tested it in the device table and works.

[jstagaman]

RDaniel,

Could you post your solution in case anyone else is having a similar issue? Thanks.

[rdaniel]

Hi,

you just have to follow exactly as explained in the document i posted above.

I was just making some silly mistakes.

By the way, tha document was really helpfull, do you know where to find more? I have searched the HP site for more documents alike and could not find them.

Thanks guys

[Piku]

Hi rdaniel,

I am facing the same problem i.e not able to generate the activity.I followed the same as in document but no success.
Does any one else implemented the same for device?
I am using SM7.03


regards,

[Piku]

However I am not getting any error but no activity record is generating.