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 |
Just a quick note of what I have in the hopper. SonicWall SSL-VPN NetExtender client configuration in Ubuntu. Migrating manager information from AD into EMC Infra (EMC Ionix). Scripting SQL Server maintenance plans for flexibility.
An update is available now only through Apple Software Update. As of right now, download was not found on the apple.com website.
A while back I posted instructions for getting the Aircard 875 to work with Ubuntu Feisty. I am now updating this for Hardy Heron. For me the configuration was much simpler. Here is some information regarding the hardware/software I am using.
- IBM Thinkpad
- Cingular Aircard 875 (note, this is really a Sierra card)
- Ubuntu Hardy Heron 8.04 (updated system as of 20080510)
Read more…
If you know me, then you know I am a fan of drum and bugle corps. After high school I marched for a number of years with the Harrisburg Westshoremen. Each year since the corps folded former members as well new members come together for the Westshoremen World Tour. This is my second year playing since returning from living out west.
Read more…
The last meeting of the Dublin Wine Meetup Group was January 13th. The event was held at J Gilbert’s Wood Fired Steaks. There was a special menu put together for the event and guests were also free to order from their regular menu. This is the menu that was prepared:
First Course (choice of one)
- Crab Bisque
- House Salad
- Ceasar Salad
Entree (choice of one)
- Pan Roasted Chicken Marsala
- 10oz Top Sirloin
- Five Spice Chicken Penne Pasta
- Salmon Buerre Blanc
- 4oz Petit Filet and BBQ Shrimp
Dessert (choice of one)
- Creme Brulee
- Chocolate Velvet Cake
I had the Crab Bisque, 10oz Top Sirloin, and Creme Brulee (in my opinion, the perfect desert). Dinner was outstanding! I would highly recommend J Gilbert’s Wood Fired Steaks. Check out the restaurant on Sunday afternoon for great specials.
Now onto the wine! We had a selection of 4 wines for the evening. Steve was gracious enough to bring in a bottle of Jones Family Vineyard Cab ’98 (Calistoga, CA). This was made by Heidi Barrett. This lead into an interesting conversation about cult wines and finding good values. The wine itself was excellent. Very complex flavors and a beautiful color.
The next up was Fess Parker Pinot Noir (Santa Barbara, CA). This was another complex wine. Lots of cherry, cola, and berry. I could have used a little less tannin. This one is a buy for me to cellar for a while to see if the tannin will mellow out.
Wynns Coonawarra Estate Cab was mixed in here somewhere. Unfortunately, I must have been involved in a conversation because my notes on this wine are missing.
There was a white on the menu, Caymus Conundrum. To me this is the swiss army of white wines. It pairs well with everything and seems to appeal to every pallet. This is a blend of 11 different white wine grapes. The exact proportions are unknown. You can read more about this wine on the Conundrum Wines web site.
It looks like the group will be getting together again in March at J Gilbert’s. If you are interested in coming to dinner, please stop by the Meetup website and register for the event.
Now this is interesting… My blog does not get too much traffic. I thought it was odd to get comments relating to my IT Room posting from the same person. I checked the IP address of 143.166.255.56 which is where the comment came from. Low and behold, this is an IP range from Dell. It looks like my suspicions were correct. It seems to me that the IT Room really is just a viral marketing campaign. I have seen similar instances where a company will hire a team of people to post on blogs to drum up traffic. That is really a shame, I was looking forward to a real web-tv-series that was not influenced by too much by outside sponsors.
Do you live in the Columbus area? Do you enjoy trying new wines? You may be interested in joining the Dublin Wine Meetup Group. This is a group of people who enjoy wine. Experience ranges from somalie to just learning the difference between pinot gris and chardonnay.
This is the Central Ohio Bacchus Society group. More information on the Bacchus Society can be found on their home page.
Last night was New Years. Being that it is a night I don’t really enjoy going out for, my wife and I decided to try some different sparklers and have a nice dinner. Dinner was great but we really had a good time with the sparklers. We had three picked out and in the batters circle.
Read more…
I have been patiently waiting for the release of “The IT Room“. This is either going to be incredible or lame. I somehow get the feeling this is going to be some kind of marketing piece. We’ll see… 11:11pm is the release time.
Recent Comments