Duplicate PCs in GLPI, not in OCS

adrianmarsh · 2011-10-26 12:42:42

Hi All,

My OCS<>GLPI sync has been running for a number of years, but I've noticed today that a number of machines are now showing duplicate in GLPI.

Things have changed in GLPI a lot since I last looked at this, but under Rules For Import And Link Computers,

Theres 3 rules:

- OCSNG server is 'SERV1'
- Computer to import : Serial Number is already present in GLPI YES
- Computer to import : Computer's name is already present in GLPI YES

Under Actions:

OCSNG link Assign Link if possible

So if I've got that right, it should only link if both the Serial and Computer name is the same right ?

Does it create a new entity if either is different?

(in my examination so far, machines that are Dupes do have the same Serial and Computer name exactly).

As a result, I could really do with a way of merging the Computer items, as I've finance data, associated tickets etc.
I had a look in the forums, and in the plugins list, but haven't seen anything conclusive.

I've asked something similar previously back in 2010:

http://www.glpi-project.org/forum/viewt … p?id=18669

remi · 2011-10-26 12:58:24

Try with glpi 0.80.5 which fixes some bug in ocs links, and don't forget to "clean OCS links", at least once, after the update.

adrianmarsh · 2011-10-26 15:26:44

Hi Remi,

Thanks for that, I'll take a look. Looking at some sample machines though, and assuming that when it 'split' leaves the last OCS sync date alone, some go back over 6 months ago.

When I could really do with now, is a way of merging two computers into one, so that I don't have to do it by hand.

adrianmarsh · 2011-10-26 15:56:13

Actually - what does the 'Clean ocs links' do ?

I just looked at that, and all the machines its showing in that list, all have several duplicates.

adrianmarsh · 2011-10-26 17:23:55

Ok,

I've upgraded to 0.80.5 and run the clean OCS links.

I'm still finding duplicates, and for example, it looks to me as though one issue may be the "viewing".
For example, I have two computers showing in the computer.php output, but in actual fact, both have a GLPI Computer ID of 342 - so its the same entry, being shown twice in the viewer...

Last edited by adrianmarsh (2011-10-26 17:24:22)

adrianmarsh · 2011-10-26 17:28:06

ohhh even weirder....

342 in the 'list view' shows two different OCS last-sync dates... but when I click on each individual "computer", it shows no OCS link at all for either...

adrianmarsh · 2011-10-26 17:37:13

If I run a SQL command : SELECT * FROM `glpi`.`glpi_computers` WHERE id = '342'
then it only returns one line, but GLPI shows two rows.

So this one seems like a bogus duplicate ??

EDIT: After the OCS Clean link (which has now thrown some of my good data into the bin :-( ), I now see 4 sets of dual-duplicates in the list. However, 3 of the sets all point to the same internal computer ID per set (but give different bits of data in the list - Service Pack etc).

Last edited by adrianmarsh (2011-10-26 18:03:25)

remi · 2011-10-26 18:52:45

Can you check content of glpi_ocslinks for the computer which have 4 entries (search computers_id) ?
Also check than the linked computer exists in OCS DB (glpi_ocslinks.ocsid => hardware.ID)

It seems you have more than 1 link to OCS for this computer (which should not be possible, bug fixed in previous GLPI version)
Probably, your rules are not really well configured...

I think "clean OCS links" should have delete this... (except if the linked computer really exists in OCS...)

adrianmarsh · 2011-10-26 19:02:15

Hi Remi,

I will do that. For now I've stopped the auto-sync. I also looked into OCS, and found a few 'duplicates' in there and I've cleaned those out. Unfortunately GLPI then removed some machines into Trash (I've restored them).

Now that I've done all that, the weird dupes-but-not seem to of gone...

For my sync config:

I'm not too sure about the rules myself, but they've been there since way back in 0.72.x I think...

basically I want to sync based on HOSTNAME and SERIAL #.

Heres the current rule:

http://uploadpic.org/v.php?img=TdgAdF7cyD

I'm not really sure how that imports 'new' machines, but it seems to, and I've only 1 rule.

remi · 2011-10-26 19:08:33

> Now that I've done all that, the weird dupes-but-not seem to of gone...
Ok. It was what I expect.

With 0.80.5, this issue should not happen anymore.

remi · 2011-10-26 19:09:07

> Unfortunately GLPI then removed some machines into Trash (I've restored them).
This is a configurable behavior.

adrianmarsh · 2011-10-26 22:51:15

Hi Remi,

yes I found that option afterwards..

I think I've figured out some of the issues around the auto-import too. I'll post back if I can't figure something out.

adrianmarsh · 2011-10-26 23:06:06

One question,

Does the ocsng automatic actions, use the Rules when linking machines ??

As a test, I changed my link rule to the below, expecting GLPI to only sync one computer, instead, it brought in 20
I recrafted it to avoid any OCS messups involving N/A as the serial, and then added the last UBIQ-DELL249 so it would restrict it to just one machine (for testing).

the logical Operator is AND, so I expected it to AND all the operations together, where only 1 machine should match.

http://uploadpic.org/v.php?img=o2WUOCkIqL

remi · 2011-10-27 07:15:07

> Does the ocsng automatic actions, use the Rules when linking machines ??
Yes. And only for new computer (to make a choice between link or import)

adrianmarsh · 2011-10-27 10:37:49

So looking into this in more depth, and after checking the wiki (I'm guessing thats out of date now).

In the Actions:

Whats the difference between "Link if possible" and "Link if possible, otherwise imports declined"
- I'm guessing that means: "if this rule doesn't match, then no import and continue process rules" and "if this rule doesn't match, no import and stop processing" ?

What does 'to be unaware of import' mean ?

And just so I understand the ocsng automatic action:

- It always imports existing machines (ignoring any rules) ?
- For new computers only, then the rules are used to 'link' to an existing GLPI Computer object.
- If we delete all the Rules, then a 'new computer' would never get imported - right ?

Last edited by adrianmarsh (2011-10-27 14:03:57)

adrianmarsh · 2011-11-03 19:16:14

Ok,

So I just added a brand new machine to OCS, that GLPI wouldn't be able to match to an existing machine.
I expected the machine not be be automatically imported, as I have a rule that says:
"Computer to import : Serial Number is already present in GLPI Yes"

Yet GLPI imported the machine as a new object.

If I don't want this to happen - how do I stop it ??

I noticed theres another ruleset under:

"Rules for assigning a computer to an entity"

Would that be the cause for the new creation ??

solenda · 2011-11-25 13:14:31

hello!! Very interesting discussion glad that I came across such informative post

Forum GLPI-Project

Announcement

#1 2011-10-26 12:42:42

Duplicate PCs in GLPI, not in OCS

#2 2011-10-26 12:58:24

Re: Duplicate PCs in GLPI, not in OCS

#3 2011-10-26 15:26:44

Re: Duplicate PCs in GLPI, not in OCS

#4 2011-10-26 15:56:13

Re: Duplicate PCs in GLPI, not in OCS

#5 2011-10-26 17:23:55

Re: Duplicate PCs in GLPI, not in OCS

#6 2011-10-26 17:28:06

Re: Duplicate PCs in GLPI, not in OCS

#7 2011-10-26 17:37:13

Re: Duplicate PCs in GLPI, not in OCS

#8 2011-10-26 18:52:45

Re: Duplicate PCs in GLPI, not in OCS

#9 2011-10-26 19:02:15

Re: Duplicate PCs in GLPI, not in OCS

#10 2011-10-26 19:08:33

Re: Duplicate PCs in GLPI, not in OCS

#11 2011-10-26 19:09:07

Re: Duplicate PCs in GLPI, not in OCS

#12 2011-10-26 22:51:15

Re: Duplicate PCs in GLPI, not in OCS

#13 2011-10-26 23:06:06

Re: Duplicate PCs in GLPI, not in OCS

#14 2011-10-27 07:15:07

Re: Duplicate PCs in GLPI, not in OCS

#15 2011-10-27 10:37:49

Re: Duplicate PCs in GLPI, not in OCS

#16 2011-11-03 19:16:14

Re: Duplicate PCs in GLPI, not in OCS

#17 2011-11-25 13:14:31

Re: Duplicate PCs in GLPI, not in OCS

Board footer