My last post had a simple script for dumping out all the users in a site collection – (the post said farm, but that wasn’t the code that got posted)

I’ve had a chance (and need) to work with the script and made a few nice improvements

• There are a few commented out if statements you can uncomment if you want to search for a particular user or domain
• The color output and indentation is a little better in this script
• The code dumps all it’s output into a single CSV file you can import into Excel, Access or any tool of your likeing

That last bullet point really can’t be under estimated.
Some ideas:

• You can save the list as a reference of what your group memberships were on a given day (note I didnt say permissions)
• You could import the list into access or excel, and do queries all day long

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

#getalluserinaSiteCollection
Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue
$iissite = get-spwebapplication | where {$_.url -eq "http://www.yoursite.com/"}
$iissite
$header = "type,user,group,weburl,webname"
$header | out-file filename.txt 
foreach ($SiteCollection in $iissite.sites)
{
    write-host $SiteCollection -foregroundcolor Blue	
    foreach ($web in $SiteCollection.Allwebs)
    { 
         write-host "    " $web.url $web.name "users:" -foregroundcolor yellow
         # Write-host "        " $web.users | select name 
         foreach ($userw in $web.users)
         {
            #if ($userw -like "Domain\*")
            #{
				write-host "        " $userw -foregroundcolor white
				#$msg = ("{0},{1} user:{2}" -f $web.url,$web.name, $userw)
				$msg = ("RootUser,{0},-,{1},{2}" -f $userw, $web.url,$web.name) 
				$msg | out-file filename.txt -append
            #  }
           }
 
		 foreach ($group in $web.Groups)
		{
                    Write-host "        " $web.url $group.name: -foregroundcolor green
		     foreach ($user in $group.users)
             { 
				# if ($user -like "DOMAIN\*")
				 #{   
					  Write-host "            " $user -foregroundcolor white
					  #$msg = ("{0},{1},group:{2}, user:{3}" -f $web.url, $web.name, $group, $user)
					  $msg = ("GroupUser,{0},{1},{2},{3}" -f $user, $group, $web.url, $web.name)
					  $msg | out-file filename.txt -append
				 #}
             }
		}	
	}
 
}

As a follow up to the last article, this script will enable versions on every list on a given “web App” (IIS site)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue
 
#note here - if you remove the where statement, you can do a foreach statement that lets you loop though each IIS site you have
$iissite = get-spwebapplication | where {$_.url -eq "http://www.yourwebsite.com/"}
$iissite
foreach ($SiteCollection in $iissite.sites)
{
    write-host $SiteCollection -foregroundcolor Blue
    foreach ($oneweb in $SiteCollection.allwebs)
    {
	   write-host  $iissite.url $oneweb -foregroundcolor Green
	   #now this is is where we look at the lists
	   $lists = $oneweb.lists
       foreach ($list in $lists)
       {
          if($list.EnableVersioning -eq $false)
          {
              write-host  $iissite.url $oneweb"/"$list"/ is a not using versions" -foregroundcolor yellow
              #$list.Enableversioning = $true
              #$List.MajorVersionLimit = 3
              #$list.update()
          }
          else
          {
              Write-host  $iissite.url $oneweb"/"$list"/ has versions enabled! "
          }
       } 
	}
}

Every now and then I need a way to pull all of the lines from a log file that match a certain string.

An example of this would be sharepoint uls logs – every error gets a unique ID number, and the errors can cover 20-30 lines at times.

if all these lines were together, that’d be easy, but often they are not together so a grep like tool comes in handy.

Thanks to a google search and the scripthacks website, it looks like there is a command in windows for this already:

Findstr

http://scripthacks.wordpress.com/2008/09/16/grep-equivalent-for-windows-string-parsing/

Basically, if you open a command prompt and cd to the logs directory,

you can enter something like this:

Findstr “Correlation ID to find” filename

or

findstr “Correlation ID to find” *.log 

 which will look though all the log files in that directory (This can take forever if there are lots of large files)

 Of course you can save the results by adding  > c:\temp\findresults.txt to the end of the line…

A handy feature for SharePoint admins with lots of log files might be the /F:file flag

basically, this reads the file list from a file.

Why would you want this?

Because you can easily dump a list of all files to a file with this command:

DIR /B *.log > filelist.txt

once you have this list (mine was 435 lines long!) , you can easily edit it in notepad and reduce the list down to the date range you’re after, this could take you from say, 435 lines down to 24

you’d then do your search with Findstr like this:

Findstr “Correlation ID to find” /F:filelist.txt

The new juniper 6.5 client seems work with OSX 10.6.x better than the old ones did – it no longer requires creating a directory and setting permissions from the command line.

That said, my upgrade seemed to go ok, but a few days later, it stopped working – saying it was unable to download files from the URL of my webvpn.

I did an uninstall (I used appdelete) then downloaded the VPN client from the VPN
it turns out the client is easily obtained manually by using
(URL of your webvpn)/dana-cached/nc/NetworkConnect.dmg
this downloads the disk image file, then you can run the setup program from there – once I did that, it worked fine without any further modifications.

(thanks to William (post #9) on http://forums.juniper.net/t5/SSL-VPN/Snow-Leopard-Network-Connect-Fix/m-p/29985)

I recently rebuilt my home domain controller and renamed my home domain that I use internally.

As a result, all the links to my subversion server are now broken.

In other words, my local working copy thinks it’s linked to a subversion server that it can no longer reach.

if only there were a way to update my local copy to let it know where to look…

first I opened terminal (on a mac here, open the cmd prompt on windows)

cd to the working directory

enter svn info – this will display where subversion thinks it’s pointing to

enter svn switch –relocate FROM http://oldpath  TO http://newpath

Video: CODA & SUBVERSION HOW TO

I did a video tutorial recently on how to use CODA (A popular mac editor used by web designers) with the Source Control System Subversion (Using Beanstalkapp.com’s free account offering)

The video is just under 20 minutes long and covers:

Setting up a free account on BeanstalkApp.com
How to configure the free account.
How to configure the ‘sites’ tab in Coda to work with the free account.
How to push changes to the Subversion Server (in this case Beanstalkapp)

How to compare an old revision with the current one.

How to ‘roll back’ a code change to an older version that’s in Subversion.

I’m working on a project in PHP at the moment.

Nothing gets a project moving like dropping a good grid control on  a page, spending 2 minutes setting a few properties and having a nice editable grid.

For ASP.NET, I’ve used the obout.com grid before with pretty good results.

Since this is my first PHP project I thought I’d see what grids are out there.

Here’s what I found…

———————

PlatinumGrid – only works with Delphi – no go.
PHPEzyGrid  -sucked – no inline editing.

KoolPHP.net $130 for the suite – nice flexibility – other tools too (combo box, calendar etc)

AppHP.com’s grid – looks nice – cheap $35

phpgrid.com – requires zend optimizer $99

Active Widgets –  too expensive ($500)

DHTMLX – I like that this is actually a Javascript grid – The  good part about this is that the knowledge gained and the grid itself could be used on other platforms (ie ASP.NET) The bad is that there’s some back end server code that needs to be written. also kind of pricey ($200-450) Typically with a pure Javascript based grid, the back end has to be written 100% by you, however, they have a connector product (still in beta no price given) The nice thing here is that the connector works with php, asp.net and jsp.

eyesis – Does not seem to have the features of other grids (no inline editing)
On the plus side, it does seem very easy to use, so there are likely places where this could be a good fit (last update was Dec 2008 however…)

ExtJS is another javascript control set – they claim to have a bunch of big customers.

It’s not cheap ($330) but like DHTMLx you are buying a whole slew of tools.

One nice thing about ExtJS is that they have a designer tool for it.
They also offer phone support (paid not free)

jQuery Grid (jqGrid) – this is a popular javascript grid for use with the jQuery framework. -$300 per platform (PHP/ASP.net )

datatables.net – (jQuery based – donation based)

SlickGrid (http://github.com/mleibman/SlickGrid)
This is my favorate from an end user perspective for it’s inline editing – it’s just like a spreadsheet.