jbmurphy.com

  • SQL query to find number of WordPress posts per week

    I wanted to know how many posts I have been creating each week. Here is a quick MySQL query to find out:

    SELECT DISTINCT extract(week from date(post_date)) AS WeekNumber, count( * ) AS Posts 
FROM wp_posts where post_type = 'post' AND post_status = 'publish' AND post_date like '%2012-%' 
GROUP BY WeekNumber;

    Returns:

    +------------+-------+
| WeekNumber | Posts |
+------------+-------+
|          1 |     4 | 
|          2 |     3 | 
|          3 |     3 | 
|          4 |     3 | 
|          5 |     3 | 
|          6 |     2 | 
|          7 |     3 | 
|          8 |     1 | 
|          9 |     2 | 
|         10 |     2 | 
|         11 |     3 | 
|         12 |     2 | 
|         13 |     2 | 
|         14 |     3 | 
+------------+-------+

  • PowerShell how to create an object (Note to Self)

    $test = new-object psobject -Property @{
Name = 'John Doe'
Age = 3
Amount = 10.1
MixedItems = (1,2,3,"a")
NumericItems = (1,2,3)
StringItems = ("a","b","c")
}

Another example:

$Object = New-Object PSObject -Property @{
        LineNumber       = $LineNumber
        Date             = $TodayDate
        ServerName       = $svr
        DatabaseName     = $Database
        UserName         = $user.name
        CreateDate       = $CreateDate
        DateLastModified = $DateLastModified
        AsymMetricKey    = $user.AsymMetricKey
        DefaultSchema    = $user.DefaultSchema
        HasDBAccess      = $user.HasDBAccess
        ID               = $user.ID
        LoginType        = $user.LoginType
        Login            = $user.Login
        Orphan           = ($user.Login -eq "")
    }

    Second example taken from here

  • PowerShell to get all items in a SharePoint 2007 list via Web Services/SOAP

    I wanted to get a list’s contents in a SharePoint 2007 site via PowerShell. I ran into only one issue – how to handle the pagination. When creating the Xml to include the next page, I was running into formatting issues because the text contained a “=”. This link suggested that I create the XML element first then add the innerText after. Worked after that!

    TheBelow is my script to get the contents of a SharePoint 2007 list.

     

    $listName = "List Name"
$xmlDoc = new-object System.Xml.XmlDocument
$query = $xmlDoc.CreateElement("Query")
$viewFields = $xmlDoc.CreateElement("ViewFields")
$queryOptions = $xmlDoc.CreateElement("QueryOptions")
$rowLimit = "50"
$service = New-WebServiceProxy -UseDefaultCredential -uri http://sharepoint2007.comapny.com/_vti_bin/lists.asmx?WSDL
$nextPage=$true
while($nextPage){
$list = $service.GetListItems($listName, "", $query, $viewFields, $rowLimit, $queryOptions, "")
$list.data.row | select ows_ID,ows_Created,ows_Title
if ($list.data.ListItemCollectionPositionNext){
$nextPage=@"
<Paging ListItemCollectionPositionNext="" />
"@
$queryOptions.set_InnerXml($nextPage)
$queryOptions.ChildNodes[0].Attributes["ListItemCollectionPositionNext"].InnerText = "$($list.data.ListItemCollectionPositionNext)"
}
else {
write-host "done"
$nextPage=$false
}
}

  • 4500 visits in March!

    Hope your vist was somewhat helpful!

  • PowerShell: redirect (System.Xml.XmlDocument).Save() to console

    I saw the code below somewhere, and could not remember how to do it later when I needed it. System.Xml.XmlDocument has a built in method to save the document to a file. I wanted to simulate that, but redirect it to the console. I finally found the code how to do it.

    $xml = new-object System.Xml.XmlDocument
    $xml.Save([Console]::Out)

    Now I know where to look to remind myself.

  • PowerShell to list SharePoint 2007 lists

    I wanted to get a quick list of all the lists in our SharePoint 2007 environment. With PowerShell 2, it is easy.

    $lists = New-WebServiceProxy -UseDefaultCredential -uri http://sharepoint2007.company.com/_vti_bin/lists.asmx?WSDL
$lists.GetListCollection().List | select Title, Name

  • PowerShell to get a users DistinguishedName

    Why can’t I remember that to find a user’s Distinguished Name all i have to do is type the PowerShell cmdlet:

    Get-ADUser username

    And for a group:

    Get-ADGroup groupname

    And for a computer:

    Get-ADComputer computername

    Why can’t I remember that? It is also a quick way to find the OU of an object!

  • How to setup a remote syslog server in CentOS 6

    I wanted to have a cisco device send it’s logs to a Centos box for troubleshooting. I just wanted to do a “tail -f” against the error logs. Seems that syslog is now rsyslog in Centos 6. To setup rsyslog to accept syslog logs from other devices, you need to:

    1. uncomment out the following lines (not the description lines, the ones that start with “$”)

    # Provides UDP syslog reception
    $ModLoad imudp.so
    $UDPServerRun 514

    # Provides TCP syslog reception
    $ModLoad imtcp.so
    $InputTCPServerRun 514

    2. Add a line or two like these below to say where you want the logs written:

    :fromhost-ip,startswith,’192.168.1.’ /var/log/remote.log
    & ~
    :fromhost-ip,isequal,”192.168.1.33″ /var/log/servername.log
    & ~

    3. service restart rsyslogd

    4. add a hole in iptables for 514 (UDP and TCP)

    -A INPUT -m state –state NEW -m udp -p udp –dport 514 -j ACCEPT
    -A INPUT -m state –state NEW -m tcp -p tcp –dport 514 -j ACCEPT

    5. service iptables restart

    6. create a new logrotate.d config file in /etc/logrotate.d:

    /var/log/remote.log
    {
    daily
    rotate 5
    missingok
    notifempty
    sharedscripts
    postrotate
    /bin/kill -HUP `cat /var/run/syslogd.pid 2> /dev/null` 2> /dev/null || true
    endscript
    }