The Idea is to Observe, Discover, Ponder, Propose, and Do.
Heads up
Released this morning on Oct 13th 2016 if you have any of the following a very strong chance of in place upgrade trying then rolling back. Surprised I don’t see McAfee a
Background
When your IT administrators update their exchange server or you switch to a new DNS alias or up in the cloud windows adds these new Generic Credentials into the Credentials Vault of your user account. When more than one exists for a single account Outlook gets confused and prompts you.
Solution
Another fun tip to make outlook run better is to use the/CleanFreeBusy start up switch.
| /cleanfreebusy | Clears and regenerates free/busy information. This switch can only be used when you are able to connect to your Microsoft Exchange server. | 2000, 2002/XP, 2003, 2007, 2010 |
The /CleanFreeBusy switch will reset all of your pending Outlook meeting invites. This will clear any conflicts and again make Outlook faster. This was deprecated for 2013.
For Office 2013, 2016, and O365 you use this: https://support.microsoft.com/en-us/kb/2555008
Great Reference for Outlook Command Lines
From a Post Mr.Brown
The question came up recently on how to identify which collections are based on Active Directory OU membership in Microsoft System Center Configuration Manager (SCCM) Current Branch
There are tons of guides on how to setup a collection based on OU membership.. but now that you have.. how many have you created?
This is quite simple direct SQL query:
SELECT [CollectionID] ,[RuleName] ,[QueryID] ,[QueryExpression] ,[LimitToCollectionID] FROM [SMS_ABC].[dbo].[v_CollectionRuleQuery] where QueryExpression like ‘%System_OU%’
* not all collection memberships need to be based on System OU. Varitations will be needed based on requirements
* The above query is based on a view. If you want to see the SQL you would query the table Collection_Rules_SQL
The SQL table Collection_Rules_SQL also has the WQL versions of the same query. This is extremely useful for figuring out the SQL tables involved with any WQL query from collections or the Query node. You can also get this translation from the SMSProv.log file but that is like searching for a needle in a hay stack while the hack stack is getting bigger and may disappear in a roll over.
A nice bit of documentation at Creating Custom Reports by Using SQL Server Views in System Center 2012 Configuration Manager
Otherwise, happy spelunking!
At the bottom of this post I originally wrote a VBS that deletes files out of ITunes if the location does not exist. I did the rewrite into PowerShell…
(new-object –com itunes.application).LibraryPlaylist.Tracks | ?{ $_.Location -eq $null } | %{ $_.Delete() }
The PowerShell above only removes the item out of ITunes if the location is NULL. I need to put in a step to check to see if the location is valid.
ITTrackKindFile = 1
deletedTracks = 0
on error resume next
set iTunesApp = WScript.CreateObject("iTunes.Application")
set mainLibrary = iTunesApp.LibraryPlaylist
set tracks = mainLibrary.Tracks
Set FSO = CreateObject("Scripting.FileSystemObject")
for each currTrack in tracks
' is this a file track?
if (currTrack.Kind = ITTrackKindFile) then
' yes, does it have an empty location?
if (currTrack.Location = "") then
' yes, delete it
wscript.echo currtrack.name & " - " & currTrack.Location
currTrack.Delete()
deletedTracks = deletedTracks + 1
else
'wscript.echo currTrack.Location
if not fso.fileExists(currTrack.Location) then
wscript.echo currTrack.name & currTrack.Location
pause
end if
end if
end if
next
wscript.echo "-----------------------------------------------------"
wscript.echo "deletedTracks = " & deletedTracks
Over the past couple of years I travel quite a lot. As such, I tend to load up on digital format. However, some of my older files have some nasty names or bad quality.
This has led to me to start grooming my 15,000+ song catalog. That number does not include another 15,000+ audio book files. I love to listen to books while running.
As I was going through the folders of CD rips, iTunes purchases, and other sundry file droppings… I was feeling a bit overwhelmed.
Trying to scope the issue I went for the following categories
Today I am going to talk about how I used PowerShell to identify files below a certain bitrate threshold. Example, I want to get all MP3 files with a bit rate less than or equal to 100. Then I want to delete them… as they sound even worse on digital players (like the iPhone)
Enjoy!
function Get-Mp3FilesLessThan( [string]$directory = "$pwd", [int]$minimumBitrate = 32, [string]$FileTypeExt = "*.mp3" ) {
$shellObject = New-Object -ComObject Shell.Application
$bitrateAttribute = 0
# Find all mp3 files under the given directory
$mp3Files = Get-ChildItem $directory -recurse -filter $FileTypeExt
foreach( $file in $mp3Files ) {
# Get a shell object to retrieve file metadata.
$directoryObject = $shellObject.NameSpace( $file.Directory.FullName )
$fileObject = $directoryObject.ParseName( $file.Name )
# Find the index of the bit rate attribute, if necessary.
for( $index = 5; -not $bitrateAttribute; ++$index ) {
$name = $directoryObject.GetDetailsOf( $directoryObject.Items, $index )
if( $name -eq 'Bit rate' ) { $bitrateAttribute = $index }
}
# Get the bit rate of the file.
$bitrateString = $directoryObject.GetDetailsOf( $fileObject, $bitrateAttribute )
if( $bitrateString -match '\d+' ) { [int]$bitrate = $matches[0] }
else { $bitrate = -1 }
# If the file has less than or equal to the desired bit rate, include it in the results.
if( $bitrate -le $minimumBitrate ) { $file }
}
}
I have been an avid user, contributor, speaker, and blogger on www.myitforum.com since 2005. It has been an amazing journey. However with the most current owners a lot of great content is disappearing. As such I am attempting to grab content before it disappears completely.
The email lists are by far the best part still.
As such sorry for all the ancient posts coming over in the next few days.
http://myitforum.com/myitforumwp/author/scassells/
As a Level 5 Local Guide, you can:
Get access to test new Google products before public release
Apply to attend our Level 5 Local Guides summit
This is the highest level you can currently achieve with Google Local Guides. Other levels have nice Benefits. Like 1TB of Google Drive storage. I travel a lot for work and I tried to writing on a lot of different sites like Travelzoo, yelp, etc. I fixated on maps.google.com mainly because it is ubiquitous and fairly easy to add info. I hope you enjoy one of my piratical posts on any of the several hundred locations.
