Aug
21
Not really useful, but hey it’s Sunday and you’re bored 
Small powershell script that makes a graph about the movie types in the Spotweb database. The following requires “LibraryChart.ps1 and the MySQL .NET Connector. Eventually this will give the following output (I’ve cut out the form around the graph)
Permanent link to this article: http://www.g60.nl/powershell/spotweb-statistics
Aug
02
Spotweb already allows to make filters however when searching some stuff I don’t want still shows up. Also with really deleting posts from the database I make sure my girlfriend doesn’t download CAM versions.
Also I’m deleting all TV shows from the database. I”m already using Sickbeard for this.
Since spotweb can be configured as Newsnab provider in Sickbeard I’m not deleting this anymore.
See SQL code in full view.
Permanent link to this article: http://www.g60.nl/usenet/spotweb/remove-categories-from-spotweb-database
Jul
22
At work we have the procedure that every computeraccount has a specific description containing location, pc model, username. People were filling all this info by hand, not really efficient but it sort of worked the first few weeks…ended up with having 1000+ computer accounts having no description at all.
Now the good part, last year we’ve purchased Lansweeper for some reporting on servers within out domains. Now we didn’t setup the filters so we would only scan servers so we now have all servers/desktops/notebooks into a SQL database for Lansweeper. All info we needed for setting the description is in there we just needed to glue it together so here we go.
Permanent link to this article: http://www.g60.nl/powershell/filling-active-directory-descriptions