Author Archive for admin

IdleTunes – Dead Tracks – ITunes

I store music files across multiple harddrives and move them around a lot as I download and what not. The resuling moves often create dead track in Itunes and since I’m making a lot of moves – I hate having to reupdate the tracks in ITunes manually.

I found a utility called idletunes which helps with removing those pesky (!) dead tracks under ITunes. I know you can hit delete. It seems like there should be a search field by missing track. If it is in ITunes, I couldn’t find it.

If found another tool called the ITunes Library Updater which seems to perform a similar function and much closer to what I was looking for.

Script to Extract Email Addresses from AD

I had needed to setup a unix based mail gateway to relay mail through to Exchange on one of my networks.

I had found an article on how to do this The script below reflects a modification of a script I found Mail Relay/; however, it needed some adjustment.

I made some modifications below to handle contacts and groups.

‘ Export all valid recipients (= proxyAddresses) into a
‘ file virtual.txt

‘ Ferdinand Hoffmann & Patrick Koetter
‘ 20021100901
‘ Shamelessly stolen from
‘ http://www.microsoft.com/windows2000/techinfo/ \
‘ planning/activedirectory/bulksteps.asp

‘Global variables
Dim Container
Dim OutPutFile
Dim FileSystem

‘Initialize global variables
Set FileSystem = WScript.CreateObject(“Scripting.FileSystemObject”)
Set OutPutFile = FileSystem.CreateTextFile(“virtual.txt”, True)
Set Container=GetObject(“LDAP://DC=local,DC=p2sol,DC=com”)

‘Enumerate Container
EnumerateUsers Container

‘Clean up
OutPutFile.Close
Set FileSystem = Nothing
Set Container = Nothing
Dim Alias

‘Say Finished when your done
WScript.Echo “Finished”
WScript.Quit(0)

‘List all Users
Sub EnumerateUsers(Cont)
Dim User

‘Go through all Users and select them
For Each User In Cont
Select Case LCase(User.Class)

Case “contact”
If Not IsEmpty(User.Mail) Then
OutPutFile.WriteLine “alias: SMTP ” & User.Mail
End If

‘If you find groups
Case “group”
‘Select all proxyAddresses
If Not IsEmpty(User.proxyAddresses) Then
For Each Alias in User.proxyAddresses
OutPutFile.WriteLine “alias: ” & Alias
‘WScript.Echo Alias
Next
End If

‘If you find Users
Case “user”
‘Select all proxyAddresses
If Not IsEmpty(User.proxyAddresses) Then
For Each Alias in User.proxyAddresses
OutPutFile.WriteLine “alias: ” & Alias
‘WScript.Echo Alias
Next
End If

Case “organizationalunit” , “container”
EnumerateUsers User

End Select
Next
End Sub

WebKeePass

Found an awesome program for sharing / managing passwords within a smaller organization. It is called WebKeePass and is based on KeePass to a limited degree.

http://pauljones.mine.nu/webkeepass/

I managed to get this tool working with Active Directory based authentication. The trick is to create a user called “admin” in AD after you get AD authentication working. Then you can use this user to create rights and privileges for other users within WKP. Unfortunately, the access controls are not integrated with AD groups, but again this seems to be targeted towards smaller organizations.

NeoMail

Email email email. I have for years tried to better organize my email and eventually – due to the sheer volume it became readily apparent to me that even how much time it takes to process an email is relevant. Those seconds add up. I HATE the way outlook is designed. However, I have found a 3rd party add on to Outlook that is Outstanding. It is one of those programs that just works. It is called NeoMail.

I have include a basic screen shot below to wet your appetite, but you might want to check it out. Yes the link above is a referral, and yes I use this program on a daily basis. It helps me process up to 1000 messages a day in an effective manner. Now if I could get something similar for RSS feeds.

Zabbix – IReport – Custom Reporting Tutorial – Part 1

This is the first  art of a series of articles to get people started with JasperReports and connected to the Zabbix  health monitoring system. In the second part I’ll explain how to access your database to run simple queries and show them in a very simple report created with iReport.

The first thing we need to do to get moving is to have iReport ready. So if you haven’t got it installed do so. Next step is to have the database driver in your iReport library folder. This means that you will need a jdbc jar packaged driver copied to the ./lib/ directory of iReport’s base folder. This step is really important not doing so will not allow you to connect to the database. Most databases provide their own jdbc driver, there are many tutorials and references that speak about jdbc.

Now is the time to configure access to your database. You have to go to the menu “Data -> Connections/Datasources”. Then you must click the “New” button.

When you get this dialog, the first thing to do is to give a name to the connection “Name”. Next is to specify the driver to connect to your database.Then you’ll have to modify the JDBC URL to access your database (You can use the wizard to do this too). Finally you must specify the username and password with permission to get access to the database. It’s convenient to test the connection before saving.

With your connection ready, is time to query the database. In my case I will be using PostgreSQL and I will build a simple query to get the database table names. For this you must go to the menu “Data -> Report Query”.

When you insert your SQL query, in my case “SELECT * FROM pg_tables ORDER BY 1” iReport automatically gets the metadata for your query and stores them as report fields so you can use them during the development of your report.

Finally with the retrieved report fields we can now create our report. This is the result:

Migrate WSUS Database from Domain Controller to SQL 2005

Okay, so I had made a newbie mistake when installing WSUS into our environment about a year ago. This may occur if you have a limited number of machines for running a small network.

I installed WSUS on top of a domain controller. Everything seemed to work fine in this configuration; however, I wanted to move the database to another SQL Server so that I could better automate reporting of which systems have which updates, etc. Turns out, that it is not very straight forward on how to move the database from a domain controller to another SQL server.

Here is my solution.

I followed the instructions here, but had to modify them slightly.

Migrate WSUS from Local SQL  to Remote SQL Server

The first modification was to ATTEMPT to install SQL Server database services. This install sqlcmd.exe which will be needed for the procedure listed above. Since it is on a domain controller, the SQL Server install will fail.

Once you get to the message above, just hold your horses and switch to a command prompt after having stopped Windows Update Services and the IIS Admin service.

Execute the command listed in the Microsoft article.

Reattach the database on the remote system.

Add the machine account in SQL Server (e.g., DOMAINAME\machinename$) to the SUSDB. Make sure the role is as the Microsoft article suggested.

Next edit the registry as the article suggested. I added my remote server name, and there was one additional key that I changed to a 1. The key was named something like ServerIsRemote with a value of 0. I changed that to a 1.

Rebooted the front end WSUS server and everything worked like a champ after that.

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!