Report Server Course

Links: http://msdn.microsoft.com/en-us/library/ms153561.aspx http://msdn.microsoft.com/en-us/library/ms156500.aspx http://www.developer.com/db/article.php/10920_3727626_2 http://msdn.microsoft.com/en-us/library/ms157406(sql.90).aspx http://blogs.msdn.com/bwelcker/archive/tags/Reporting+Services/default.aspx http://www.sql-server-performance.com/articles/reporting/index.aspx http://lyon-smith.org/blogs/code-o-rama/archive/2007/03/22/visual-studio-column-guides-redux.aspx http://www.microsoft.com/downloads/details.aspx?familyid=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en http://visualstudiomagazine.com/columns/article.aspx?editorialsid=1900 Husk Report Builder 2.0 Og her er koden i forbindelse med Report server kurset d 25. - 27 feb: Private Sub LoadInformation()   'load information into list view lstView.Items.Clear()  Dim myCatalogItems As CatalogItem()myCatalogItems = rs.ListChildren("/", True)  For Each cItem As CatalogItem In myCatalogItems  Dim strValues(3) As String strValues(0) = cItem.Name strValues(1) = cItem.Path strValues(2) = cItem.Type.ToString()strValues(3) = cItem.CreatedBy lstView.Items.Add(New ListViewItem(strValues))  Next End Sub Private Sub DisplayCurrentInfo()  Me.Cursor = Cursors.WaitCursor  'display item information in messagebox Dim item As ListViewItem = lstView.SelectedItems(0)  Dim strName As String = item.SubItems(0).Text  Dim strPath As String = [...]

By |2009-02-27T14:44:04+01:00februar 27th, 2009|SQL|Kommentarer lukket til Report Server Course

Powershell Acticvesync wipe

In this Powershell sample (created with ASE) - its possible to create a simple form to let Helpdesk manage Activesync Devices, this is done by finding and wipe/unwipe the device. Feel free to change and clean-up ;-) - Try ASE - http://adminscripteditor.com/ - Its a great editor. #################################################################### # Program..........: ASExWipe.ps1                            # # Author...........: Kåre Rude Andersen ([email protected])          # # Bagground........: Utility to let helpdesk manage Activesync     # # .................: devices.                                      # #################################################################### #region Script Settings #<ScriptSettings xmlns="http://tempuri.org/ScriptSettings.xsd"> #  <ScriptPackager> #    <process>powershell.exe</process> #    <arguments /> #    <extractdir>c:\scripts</extractdir> #    <files /> #    <usedefaulticon>true</usedefaulticon> #    <showinsystray>false</showinsystray> #    <altcreds>true</altcreds> #    <efs>false</efs> #    <ntfs>false</ntfs> [...]

By |2009-02-11T17:05:46+01:00februar 11th, 2009|Powershell|1 Kommentar

Find Query-based Distribution Groups in Domain

To find all QBD groups in your domain run the following. (Remember to change the LDAP string...) On Error Resume Next Const ADS_SCOPE_SUBTREE = 2 Set objConnection = CreateObject("ADODB.Connection") Set objCommand =   CreateObject("ADODB.Command") objConnection.Provider = "ADsDSOObject" objConnection.Open "Active Directory Provider" Set objCommand.ActiveConnection = objConnection objCommand.Properties("Page Size") = 1000 objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE objCommand.CommandText = _     "SELECT cn, objectClass FROM 'LDAP://dc=coretech,dc=intra' WHERE " _         & "objectClass ='msExchDynamicDistributionList'" Set objRecordSet = objCommand.Execute objRecordSet.MoveFirst Do Until objRecordSet.EOF    Wscript.Echo objRecordSet.Fields(1).Value    objRecordSet.MoveNext Loop

By |2009-02-10T17:17:15+01:00februar 10th, 2009|Scripting & Development|3 Comments

SQL 2005 Course

Samples, Utils and Links from MOC 2780 SQL 2005 Course. Check All Databases with undocumented stored procedure: EXEC SP_MSForEachDB @command1="Print '?' DBCC CHECKDB ('?')" Another track to the same station. Declare @db VarChar(100),  @dbid int,  @hidb int Select @hidb = Max(dbid ), @dbid = 0 from master..sysdatabases While @dbid < @hidb Begin    Set @db = null    Select @db = name    From sysdatabases    Where dbid = @dbid    if @db is not null       DBCC CheckDB( @db )    Set @dbid = @dbid + 1 End Reindex all tables in a database: EXEC sp_MSforeachtable @command1=“print ’?' DBCC DBREINDEX [...]

By |2009-02-10T10:01:21+01:00februar 10th, 2009|SQL|Kommentarer lukket til SQL 2005 Course

Installing multiple applications using variables

One major benefit of using variables in the software application installation process is the ability to work with "software groups". A software group can be defined as a group of computers that share the same software package e.g. all workstations in R&D orHR. This post describes how to install multiple applications using variables on one collection. Start by categorizing all software packages Which ones need to be in the image Which ones are installed on all computers (can be added as singple Install Software steps in the task sequence) Which ones are part of a specific Software group (handled in [...]

By |2009-02-06T21:40:19+01:00februar 6th, 2009|Configuration Manager (SCCM)|4 Comments

Install software after TS finishes, but as part of the deployment process.

I some times run into problems while installing SW as a part of my Task Sequence.. Now don’t get me wrong, most times the apply  software works like a charm, and everything is installed without a glitch. But every now and then,  a piece of software comes along that just won’t install as part of the TS. To name a couple of the more resent ones i encountered, there is Cisco VPN that has a tendency to cut the network connection for just a second during installation, making the TS fail, or Lenovo(IBM) Presentation Director,  that has to have an [...]

By |2009-02-05T16:14:04+01:00februar 5th, 2009|Packaging & Installation|9 Comments