Skip to content

Instantly share code, notes, and snippets.

View KirillPashkov's full-sized avatar

Kirill Pashkov KirillPashkov

  • Russia, Moscow
View GitHub Profile
Function CreateCSV(InputMessageName,OutputMessageName,Delimiter)
Set sb = Application.CreateStringBuilder
If IsNull(Delimiter) OR IsEmpty(Delimiter) Then
Delimiter = ";"
End If
If IsNull(OutputMessageName) OR IsEmpty(OutputMessageName) Then
OutputMessageName = "CSV"
End If
Find = chr(34)
Str = "This is string with " & chr(34) & "double quotes" & chr(34) & "."
Occurrences = (Len(Str) - Len(Replace(Str,Find,Empty)) / Len(Find))
MsgBox "String: " & Str & vbCrLf &_
"Contains :" & Occurrences & " occurrences of: " & Find & "."
Function GetOccurrences(InputString,LookupString)
If _
IsNull(InputString) Or IsEmpty(InputString) Or _
IsNull(LookupString) Or IsEmpty(LookupString) _
$ps = New-Object System.Diagnostics.ProcessStartInfo
$ps.FileName = 'explorer'
$ps.Arguments = '/select, ' + $Path
[System.Diagnostics.Process]::Start($ps)
function Get-MongoEventLog (
[Parameter(Position=0)][string] $Regex = '.*',
[Parameter(Position=1)][string] $Log = $null
)
{
# Check to see if we are running the 64 bit version of Powershell.
# See http://stackoverflow.com/questions/2897569/visual-studio-deployment-project-error-when-writing-to-registry
if ([intptr]::size -eq 8) { $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.2").'(default)'; }
else { $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.2").'(default)'; }
function Get-MongoEventLog (
[Parameter(Position=0)][string] $Regex = '.*',
[Parameter(Position=1)][string] $Log = $null
)
{
Add-Type -Path "bin\MongoDB.Bson.dll";
Add-Type -Path "bin\MongoDB.Driver.dll";
$db = [MongoDB.Driver.MongoDatabase]::Create('mongodb://localhost/powershell');
[MongoDB.Driver.MongoCollection] $collection = $db['eventlogs']
# Check to see if we are running the 64 bit version of Powershell.
# See http://stackoverflow.com/questions/2897569/visual-studio-deployment-project-error-when-writing-to-registry
if ([intptr]::size -eq 8) {
$mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.2").'(default)';
}
else { $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.2").'(default)'; }
Add-Type -Path "$($mongoDriverPath)\MongoDB.Bson.dll";
Add-Type -Path "$($mongoDriverPath)\MongoDB.Driver.dll";
$mongoDriverPath = "$(Split-Path -Parent $MyInvocation.MyCommand.Path)\bin";
Add-Type -Path "$($mongoDriverPath)\MongoDB.Bson.dll";
Add-Type -Path "$($mongoDriverPath)\MongoDB.Driver.dll";
$bsonDoc = [MongoDB.Bson.BsonDocument] @{
Name = 'firstname surname'
EmailAddresses = 'username@gmail.com','username@mongodb.org'
};
#$bsonDoc.ToHashtable()
$Group = Read-Host 'Specify Group';
[void][System.Reflection.Assembly]::LoadWithPartialName('System.DirectoryServices.AccountManagement');
([System.DirectoryServices.AccountManagement.GroupPrincipal]::FindByIdentity([System.DirectoryServices.AccountManagement.ContextType]::Domain,$Group)).GetMembers(1);
Function Get-Diacritic
{
Param
(
[Parameter(Mandatory=$true)][ValidateScript({Test-Path $_})][String]$Path,
[Parameter(Mandatory=$True)][String[]]$Recepient,
[Switch]$AsHTML
)
$email = @{
function Get-Uptime {
[CmdletBinding()]
param(
[Parameter(Mandatory = $true, ValueFromPipeline = $true)][string[]]$ComputerName=$env:COMPUTERNAME
)
begin
{}
process {
$obj = New-Object PSObject
$obj | Add-Member -MemberType NoteProperty -Name ComputerName -Value $ComputerName[0]