Just a little exercise to pull data from a Sharepoint list and visualize it with a Google Treemap. My Sharepoint list was a simple query to pull Support Groups from BMC Remedy and the # of tickets ‘In Progress.’ The structure is [Title] (or Support Group), [Parent], [TicketsInProgress], [TotalTickets] // […]
Accidently killed a shared datasource for 1000 reports. Found a handy query to update all those reports with a re-created datasource. Updated a couple of reports manually in Sharepoint. Ran the following against the ReportServer database. select c.Name as reportname, d.link, d.Name as datasource, d.dsid, d.itemid from Catalog c inner […]
I have a ProjectServer with a custom field (Project Status Slide) where users have a URL for an image. I needed to retrieve the URL from the custom field and display it inline on the ProjectDetails.aspx page <div GUID=”xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx”>http://myserver/PWA/Pictures/Slide1.png</div> The source of the custom field resembles the above. I put […]
I am using SSRS to report against an Oracle database source directly. For a while I was getting the following error. Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. Apparently there is […]
Simple scripts that you can automate with the Task Scheduler to backup/cleanup your Sharepoint 2010 farm with email notifications. Backup Script try { $today = (Get-Date -Format dd-MM-yyyy) #Location of the Backup Folder [IO.Directory]::CreateDirectory(“E:BackupDailyFarmBackUp$today”) # This will actually initiate the SPFarm backup. Backup-SPFarm -Directory E:BackupFullFarmBackup$today -BackupMethod full # Backup-SPFarm -Directory […]
