The product formally known as Ionix Service Manager, formally known as Infra has been moved to VMWare and is now known as VMWare Service Manager. Since the move, there seems to be new material on the website referencing version 9. I know that this version has been talked about by EMC for a while so I am curious if it will really come out.
In other news, Microsoft has granted me access to System Center Service Manager. I am going to dig into that product to see how it compares. If it accomplishes 80% of what Infra accomplished, I may be sold.
Just a note for all of you Infra / Ionix users… The db and wrapper controls that are downloaded ARE NOT 64bit compatible. You must use the 32bit version of IE to launch Infra. This is for version 8, I have not tested version 9 yet.
Infra has been a great ITIL toolset for my department. The only downfall I have run into is some of the simpler integrations or features come at a steep price point. This integration cannot be that far out of the box for Infra but yet costs thousands of dollars. Instead I have been spending some time understanding the Infra database and have come up with the following VBS to move the manager information stored in AD into the Infra database. We have this script to run each night and it keeps everything in order.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
| LDAPRootDN = "LDAP://OU=HCL Users,DC=hcl,DC=internal"
' Infra database DSN
InfraDSN = "Driver={SQL Server};Server=data01.hcl.internal;Database=infraEnterprise;Trusted_Connection=TRUE"
set objConnection = CreateObject("ADODB.Connection")
objConnection.ConnectionString = InfraDSN
objConnection.open
' Start the process
ProcessOU(LDAPRootDN)
function ProcessOU ( DN )
set CNUsers = GetObject(DN)
for each User in CNUsers
select case User.class
case "user"
' Migrate manager information if a manager is defined
if ( User.manager <> "" ) then
MigrationCount = MigrationCount + 1
MigrateManager User.distinguishedName, User.manager
else
' No manager information on file
end if
case "organizationalUnit", "container"
' This is an OU, recurse into
ProcessOU( User.ADsPath )
end select
next
end function
function MigrateManager ( StaffDN, ManagerDN )
set Staff = GetObject("LDAP://" + StaffDN)
set Manager = GetObject("LDAP://" + ManagerDN)
strQuery = "exec sp_MigrateManager '" + Staff.GUID + "', '" + Manager.GUID + "'"
set rs = objConnection.execute(strQuery)
end function |
The following is the supporting TSQL for the sp_MigrateManager procedure.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
USE infraEnterprise
GO
IF EXISTS ( (SELECT NAME FROM sysobjects WHERE NAME = 'sp_MigrateManager' AND TYPE = 'P'))
BEGIN
DROP PROCEDURE sp_MigrateManager
END
GO
CREATE PROCEDURE sp_MigrateManager
@StaffGUID NVARCHAR(300),
@ManagerGUID NVARCHAR(300)
AS
BEGIN
DECLARE @ManagerRef INT
SELECT @ManagerRef = COALESCE(REF, 0) FROM AR_USER_ATTRIBUTES WHERE ldap_object_id = @ManagerGUID
UPDATE AR_USER_ATTRIBUTES
SET
MANAGER_REF = @ManagerRef
WHERE
ldap_object_id = @StaffGUID
END
GO |
Recent Comments