archive-gr.com » GR » I » ITGUY.GR

Total: 86

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • ...from punch cards to high up in the cloud!: Office 365 with Exchange on-premises Hybrid Deployment and Migration - A COMPLETE HOW-TO GUIDE
    then expand Groups Make sure that the MIISAdmins group exists If the group is missing create a group that is named MIISAdmins Add yourself to the group Log off from the computer and then log on to establish the new group membership in the access token Now install the Directory Synchronization Tool After the installation has finished the Microsoft Online Services Directory Synchronization Configuration Wizard starts You will need to type your Microsoft Online Services Admin Credentials as well as an on premises Enterprise Admin Credentials On the Exchange hybrid deployment check the box and click on Finish to Synchronize Directories To verify Directory Synchronization follow the instructions here To force Directory Synchronization On the computer that is running the Directory Synchronization tool navigate to the directory synchronization installation folder By default it is located here programfiles Microsoft Online Directory Sync Double click DirSyncConfigShell psc1 to open a Windows PowerShell window with the cmdlets loaded In the Windows PowerShell window type Start OnlineCoexistenceSync and then press ENTER Configuring the ADFS Proxy So now that the integration with the on premises Active Directory and Office 365 is complete it s time to configure the ADFS Proxy What Microsoft recommends and you should take this recommendation seriously is that you utilize 2 load balanced proxy servers For the purposes of this article we will use only one ADFS Proxy server but all you need to do to get your load balanced pair is essentially to configure a second ADFS Proxy and set up NLB on both as described previously in this article What you ll need for this part One Windows 2008 or 2008 R2 server Access to modify your external DNS records The certificate you used on your internal ADFS servers A working DMZ Topology Appropriate rules on your corporate firewall Here we go First of all configure your Windows server position it on the DMZ and make sure there is connectivity both to the Internet and your internal network Install the IIS Role with the default options import the certificate you installed to the internal ADFS servers and configure the bindings for port 443 Add the respective Host Name and IP address of the ADFS NLB Cluster you created earlier to the ADFS Proxy server s Hosts file Create a new A record on your public DNS server with the name sts yourdomain com exactly like the one you created on you internal DNS servers and point it to the public IP address you will use for your ADFS Proxy Configure your firewall so that HTTPS requests on this IP will be forwarded to your ADFS Proxy Make sure you can ping the load balanced internal ADFS server farm sts yourdomain com browse to this link https sts yourdomain com federationmetadata 2007 06 federationmetadata xml On IE 9 hit the Compatibility View button then you should be able to browse the XML contents Now run the ADFS 2 0 setup and select Federation Server Proxy Once completed make sure the Start the ADFS 2 0 Federation Server Proxy Configuration Wizard when this wizard closes check box is selected and click finish Once the AD FS 2 0 Federation Server Proxy Configuration Wizard starts do the following On the Specify Federation Service Name type sts yourdomain com i e the exact same name of the internal load balanced ADFS server farm we configured earlier The Use an HTTP proxy server when sending requests to this federation service IS STUPID Why on earth would we need yet another proxy to proxy our proxy s requests Make sure this check box remains unselected and hit Test Connection If network connectivity is working you will get a The specified Federation Service was contacted successfully message Hit Next and you re prompted for the logon credentials for the internal ADFS server farm Remember the ADFS service account you created That s the one You re supposed to enter the credentials in the form yourdomain adfsaccount password But first go to Server Manager s Main Page click on Configure IE ESC and turn it off for both users and administrators Don t and you ll get unable to establish a trust between the federation server proxy and the federation service errors On Ready to Apply Settings click on Next and watch the magic happen To verify the federation server proxy is operational Open Event Viewer In the details pane double click Applications and Services Logs expand AD FS 2 0 then click on Admin On the Event ID column look for event ID 198 Try this one as well Log on to a computer that sits outside your corporate network so that it will be directed to your ADFS Proxy server In an Internet Explorer window type https portal microsoftonline com In the User ID field type your corporate username e g user yourdomain com The web page should update with the You are now required to sign in at yourdomain com message Click the sign in link and in the sign in page and enter your domain credentials If this takes you to the Microsoft Online Services Portal home screen then you can pat yourself to the back the ADFS system you just configured works If not re check what we ve done so far and that you haven t skipped a step You can also check Adam Conkle s great post on this TechNet thread http social msdn microsoft com Forums en US Geneva thread bd815b4e 70be 4f1c ac7f a5e9ac5aea02 prof required Great all done then Not quite It s the on premises Exchange 2010 server s turn On your Hybrid Exchange server install Microsoft Online Services Sign in Assistant the one you installed on your ADFS Farm servers AND Microsoft Online Services Module for Windows PowerShell Open the Exchange Management Console and click the Microsoft Exchange node the top most node in the tree In the action pane click Add Exchange Forest In the friendly name type Office 365 This name will display in the console tree In the FQDN field just select Exchange Online from the drop down list DO NOT check the Logon with default credential box Click OK and a credentials dialog box appears Type the Office365 Admin account and corresponding password For example admin yourdomain onmicrosoft com password Watch in awe as your Office 365 organization appears on the EMC console Now to create a Federation Trust On EMC go to Organization Configuration and on the Actions pane click on New Federation Trust Click on New and then on finish and you re done Last but most definitely not least we need to create a Hybrid Configuration Right click under Organization Configuration and choose New Hybrid Configuration Go through the 2 steps of the wizard and click on finish This was too easy now comes the tricky part Right click on the Hybrid Configuration and choose Manage The Manage Hybrid Configuration opens On the credentials screen type in the appropriate usernames and passwords What I suggest you do is since we ve already synchronized Active Directory to enable an Active Directory user that is member of the on premises Organization Management role group as a Global Administrator in Office 365 This way you can use the same account for both fields Under Domains choose your hybrid domain On the next step you will be asked to create a TXT record on your public DNS servers with a Record Value that is a lengthy string of alphanumeric characters Check the box to confirm that the TXT record has been created Next up choose your hybrid on premises CAS and HUB servers Under Mail Flow Settings type the Public IP address of your on premises Exchange server i e the one on the public MX record then type the FQDN of the HUB server you chose in the previous step Mail Flow Security is pretty much straightforward the third party certificate is already there and for the Mail Flow Path choose the first option as discussed in the beginning of this article Click next but don t go any further just yet If you continue you will most likely get an error and the wizard will fail with something like Execution of the Get FederationInformation cmdlet had thrown an exception Federation information could not be received from the external organization OR Exception has been thrown by the target of an invocation What on earth is wrong Well either the MRSProxy is disabled or WSSecurity is disabled or the MRSProxy is unreachable from the Internet Regardless of where exactly the fault lies do all of the following On your Hybrid Server s Exchange PowerShell enter this command Set AutodiscoverVirtualDirectory Identity autodiscover Default Web Site WSSecurityAuthentication true to enable WSSecurity authentication for autodiscover on your hybrid server and On your Hybrid Server s Exchange PowerShell enter this command Set WebServicesVirtualDirectory Identity EWS Default Web Site MRSProxyEnabled true MRSProxyMaxConnections 100 The rule of thumb is that the larger number you use for the MRSProxyMaxConnections parameter the less chances there are that a timeout will occur for large simultaneous mailbox moves Create a new publishing rule for Autodiscover in your TMG server To get your hybrid scenario working you will need to set up an additional ISA TMG rule pointing to the hybrid server using the proper public names don t forget autodiscover bound to the OWA listener You need to allow All Users as opposed to Authenticated Users set authentication to No Authentication but users can authenticate directly and configure the following paths EWS mrsproxy svc WSSecurity EWS Exchange asmx WSSecurity Autodiscover Autodiscover svc Autodiscover Autodiscover svc WSSecurity After configuring the rule you need to put it above all the other Exchange rules making it the first matching rule when federation traffic hits ISA TMG Now you re ready to go through with the wizard and bask in the glory of your success We re almost done What have we done so far We ve configured our SSO domain with Office 365 set up public DNS records installed an internal ADFS server farm enabled Single Sign On configured Active Directory Synchronization installed our ADFS proxy on the DMZ verified the ADFS bit is all interoperable configured our on premises Exchange 2010 hybrid server for Office 365 Only thing left to do is to move our mailbox es up to the cloud On the EMC console go to the on premises node Recipient Configuration Mailbox Right click the mailbox you want to move and choose New Remote Move Request On the Connection Configurations windows under FQDN of the Microsoft Exchange Mailbox Replication service proxy type the Internet FQDN of your hybrid server Definitely consider typing in a domain admin credentials for this test Under Move Settings for the Target Delivery Domain browse for yourdomain mail onmicrosoft com If you followed this article to the letter the move should go without a hitch You can follow the progress of the mailbox move from Recipient Configuration Move Request in the EMC console the Office 365 federated forest you added earlier For good measure test moving that mailbox back to the on premises server On the EMC console go to the Office 365 node Recipient Configuration Mailbox Observe that the mailbox you just moved appears with a green arrow This means that a move request exists for this mailbox albeit a completed one You will need to go to Move Request underneath select the move request and click on Clear Move Request This will enable you to move the mailbox back to the on premises organization Now right click the test mailbox and click New Remote Move Request On the Connection Configurations windows under FQDN of the Microsoft Exchange Mailbox Replication service proxy type the Internet FQDN of your hybrid server Definitely type in a domain admin credentials for this test then consider using delegated permissions Under Move Settings for the Target Delivery Domain browse for yourdomain com For Remote Target Database type the on premises database you want to move the mailbox to Contrary to what other guides might say just type in the database name without the server name This should be enough to get the test mailbox moving back to your on premises exchange organization Finally it s time to test email flow Test for all possible cases From Office 365 users to Internet external recipients From Office 365 users to on premises recipients From on premises users to Office 365 recipients From Internet external email users to Office 365 recipients One potential issue here that has emerged on several of my clients If you are using TMG with Exchange Edge collocated on the same server then you might have an issue with your Edge Receive Connector By default TMG controls i e blocks all changes made on the Edge Role So if you have E Mail Policy Integration mode enabled on your TMG server chances are that the creation of the Receive Connector for Office 365 on your Edge Server has been blocked by TMG Check for EventID 31506 from Microsoft Forefront TMG Control service in the Application Log If you see this error and the Receive Connector is then this is what you should do On the TMG Management Console to to Troubleshooting and on the Tasks pane click on Control E mail configuration Integration Set the status to Disabled and enforce the policy Go to Forefront Online Protection for Exchange Administration center and make a note of the IP addresses listed under IP addresses to configure on your firewall Login to https portal microsoftonline com with a Global Administrator account Click on Outlook On the upper right hand side of the Outlook page click on Options and then See All Options On the upper left hand side click on the drop down list arrow right from Manage Myself and under Select What to Manage click on My Organization Go to Mail Control and on the right hand side of the page under Forefront Online Protection for Exchange click on Configure IP safelisting perimeter message tracing and email policies This takes you to Forefront Online Protection for Exchange for your organization Under Information click on Configuration Copy paste the IP addresses and subnet ranges to a text document then arrange them in a comma separated way like so 12 12 12 0 24 14 14 14 0 26 34 23 34 156 Now open the Exchange PowerShell on the TMG Exchange Edge server and type the following command New ReceiveConnector Name From Cloud Usage Internet RemoteIPRanges FOPE Outbound IP Addresses Bindings 0 0 0 0 25 FQDN mailserverexternalFQDN yourdomain com TlsDomainCapabilities mail messaging microsoft com AcceptOorgProtocol where FOPE Outbound IP Addresses copy paste the comma separated list from the text document This will create the receive connector and reinstate email flow from Office 365 to your on premises organization Fine tuning Now that everything s working you might want to do some fine tuning This article has great info regarding the Mailbox replication Service MRS is the service responsible for moving mailboxes importing and exporting pst files and restoring disabled and soft deleted mailboxes So depending on how you want to plan your mailbox moves and your migration to your desired hybrid model you may want to tamper with the MRS configuration accordingly That all This is all everything you need to do to get your hybrid Office 365 working Yours the ITGuy Email This BlogThis Share to Twitter Share to Facebook 19 comments Anonymous July 9 2012 at 6 01 AM Excellent post I actually found it once I was done with my deployment and re checked several things Have you had issues with single sign on such as Your organization could not sign you in to this service Reply Delete Andreas Panagopoulos July 11 2012 at 12 00 PM After numerous installations no SSO has worked without a hitch Are you using an ADFS Proxy If so have you tried my troubleshooting steps under Configuring the ADFS Proxy It sounds like authentication issues Reply Delete Anonymous July 23 2012 at 6 45 PM Very interesting tutorial But I ve got a problem I create the rule on my TMG and I check it And I ve got an error to EWS mrsproxy svc WSSecurity it can t be verified But for the others paths no problem Reply Delete Anonymous September 10 2012 at 2 53 PM one question on the hybrid emc the tarnsport hub fields are grayed out with a yellow lock is this by design or i have failed to install the hybrid correctly Reply Delete Andreas Panagopoulos September 11 2012 at 12 33 AM If you mean for example in Office365 Organization Configuration Hub Transport Transport Settings General Properties fields like Maximum Receive Size etc then yes it s by design Some of the grayed out options are configurable from the Office365 administrative portal and others are not meant to be tampered with Reply Delete Anonymous September 12 2012 at 10 07 AM thank you for your answer one last question the only way to change maximum receive size is by using power shell commands set recieveconnector i could not find any other way from office 365 is there any other option Reply Delete Anonymous November 6 2012 at 10 34 PM Hi Tanks for the awesome article When clients with mailboxes in the cloud connect via Outlook Anywhere is the data transferred via the on premise server internet connection or directly via the Microsoft datacentre Thanks Thomas Reply Delete Anonymous November 21 2012 at 9 18 AM Hey Awesome post Just loved it However have few questions for which help is much appreciated 1 How do i make ADFS proxy requests forwarded to ADFS server Should i do a port forwarding kind of thing for my ADFS Proxy 2 I have already given firewall excemptions for Exchange Online IP address ranges However my ADFS confign was failing at Connect Msolservice with the message there was no endpoint

    Original URL path: http://www.itguy.gr/2012/04/office-365-with-exchange-on-premises.html?showComment=1379678166688 (2016-01-31)
    Open archived version from archive


  • ...from punch cards to high up in the cloud!: SCVMM 2012 locale issues and Error 24374 when adding new Library Share with default resources
    for a given search string Written by Narayana Vyas Kondreddi Site http vyaskn tripod com Tested on SQL Server 7 0 and SQL Server 2000 Date modified 28th July 2002 22 50 GMT CREATE TABLE Results ColumnName nvarchar 370 ColumnValue nvarchar 3630 SET NOCOUNT ON DECLARE TableName nvarchar 256 ColumnName nvarchar 128 SearchStr2 nvarchar 110 SET TableName SET SearchStr2 QUOTENAME SearchStr WHILE TableName IS NOT NULL BEGIN SET ColumnName SET TableName SELECT MIN QUOTENAME TABLE SCHEMA QUOTENAME TABLE NAME FROM INFORMATION SCHEMA TABLES WHERE TABLE TYPE BASE TABLE AND QUOTENAME TABLE SCHEMA QUOTENAME TABLE NAME TableName AND OBJECTPROPERTY OBJECT ID QUOTENAME TABLE SCHEMA QUOTENAME TABLE NAME IsMSShipped 0 WHILE TableName IS NOT NULL AND ColumnName IS NOT NULL BEGIN SET ColumnName SELECT MIN QUOTENAME COLUMN NAME FROM INFORMATION SCHEMA COLUMNS WHERE TABLE SCHEMA PARSENAME TableName 2 AND TABLE NAME PARSENAME TableName 1 AND DATA TYPE IN char varchar nchar nvarchar AND QUOTENAME COLUMN NAME ColumnName IF ColumnName IS NOT NULL BEGIN INSERT INTO Results EXEC SELECT TableName ColumnName LEFT ColumnName 3630 FROM TableName NOLOCK WHERE ColumnName LIKE SearchStr2 END END END SELECT ColumnName ColumnValue FROM Results END So now all we have to do to search the entire database for the string refresh is this query EXEC SearchAllTables refresh Unfortunately the word refresh is referenced in 2586 columns Browsing through all these would be tedious So let s look for sqm instead EXEC SearchAllTables sqm The result looks more promising sqm is referenced in only 5 columns Entry 5 looks like it might be the winner LastSQMRefreshTime might well be related to the IsRefreshRequired error The column is PropertyName and sits inside the dbo tbl VMM GlobalSetting table so let s have a look select from dbo tbl VMM GlobalSetting Mind you this is not the actual query I did during the troubleshooting process forgot to take a screenshot so the time is not right The date time I actually saw was a couple of days before I changed the system locale back to Eng US So it was clear to me that when the System Center Virtual Machine Manager service is starting it s checking for this specific value it s not liking what it sees so it stops and prints that error in the SCVMM server s Application log Maybe deleting this value will fix the issue Or to be more exact inserting a NULL where the date time is update dbo tbl VMM GlobalSetting set PropertyValue NULL where propertyName LastSQMEngineRefreshTime checking to see the value has actually switched to NULL It has and guess what The System Center Virtual Machine Manager service now starts Now a couple of words regarding this post Granted it was an insignificant issue that I could well live with and perhaps troubleshooting it took more time than it was worth What I am interested in and the reason I believe that such posts are worth sharing is the process of troubleshooting Troubleshooting is a reward in itself as it provides you with

    Original URL path: http://www.itguy.gr/2012/02/scvmm-2012-locale-issues-and-error.html?showComment=1330785350510 (2016-01-31)
    Open archived version from archive

  • ...from punch cards to high up in the cloud!: SCVMM 2012 locale issues and Error 24374 when adding new Library Share with default resources
    for a given search string Written by Narayana Vyas Kondreddi Site http vyaskn tripod com Tested on SQL Server 7 0 and SQL Server 2000 Date modified 28th July 2002 22 50 GMT CREATE TABLE Results ColumnName nvarchar 370 ColumnValue nvarchar 3630 SET NOCOUNT ON DECLARE TableName nvarchar 256 ColumnName nvarchar 128 SearchStr2 nvarchar 110 SET TableName SET SearchStr2 QUOTENAME SearchStr WHILE TableName IS NOT NULL BEGIN SET ColumnName SET TableName SELECT MIN QUOTENAME TABLE SCHEMA QUOTENAME TABLE NAME FROM INFORMATION SCHEMA TABLES WHERE TABLE TYPE BASE TABLE AND QUOTENAME TABLE SCHEMA QUOTENAME TABLE NAME TableName AND OBJECTPROPERTY OBJECT ID QUOTENAME TABLE SCHEMA QUOTENAME TABLE NAME IsMSShipped 0 WHILE TableName IS NOT NULL AND ColumnName IS NOT NULL BEGIN SET ColumnName SELECT MIN QUOTENAME COLUMN NAME FROM INFORMATION SCHEMA COLUMNS WHERE TABLE SCHEMA PARSENAME TableName 2 AND TABLE NAME PARSENAME TableName 1 AND DATA TYPE IN char varchar nchar nvarchar AND QUOTENAME COLUMN NAME ColumnName IF ColumnName IS NOT NULL BEGIN INSERT INTO Results EXEC SELECT TableName ColumnName LEFT ColumnName 3630 FROM TableName NOLOCK WHERE ColumnName LIKE SearchStr2 END END END SELECT ColumnName ColumnValue FROM Results END So now all we have to do to search the entire database for the string refresh is this query EXEC SearchAllTables refresh Unfortunately the word refresh is referenced in 2586 columns Browsing through all these would be tedious So let s look for sqm instead EXEC SearchAllTables sqm The result looks more promising sqm is referenced in only 5 columns Entry 5 looks like it might be the winner LastSQMRefreshTime might well be related to the IsRefreshRequired error The column is PropertyName and sits inside the dbo tbl VMM GlobalSetting table so let s have a look select from dbo tbl VMM GlobalSetting Mind you this is not the actual query I did during the troubleshooting process forgot to take a screenshot so the time is not right The date time I actually saw was a couple of days before I changed the system locale back to Eng US So it was clear to me that when the System Center Virtual Machine Manager service is starting it s checking for this specific value it s not liking what it sees so it stops and prints that error in the SCVMM server s Application log Maybe deleting this value will fix the issue Or to be more exact inserting a NULL where the date time is update dbo tbl VMM GlobalSetting set PropertyValue NULL where propertyName LastSQMEngineRefreshTime checking to see the value has actually switched to NULL It has and guess what The System Center Virtual Machine Manager service now starts Now a couple of words regarding this post Granted it was an insignificant issue that I could well live with and perhaps troubleshooting it took more time than it was worth What I am interested in and the reason I believe that such posts are worth sharing is the process of troubleshooting Troubleshooting is a reward in itself as it provides you with

    Original URL path: http://www.itguy.gr/2012/02/scvmm-2012-locale-issues-and-error.html?showComment=1330789394949 (2016-01-31)
    Open archived version from archive

  • ...from punch cards to high up in the cloud!: I'm an IT Manager... nobody loves me!
    work increase your visibility and generate the appreciation you feel is due to you The monolithic days of IT where people worked in cubicles staring on screens all day are gone Today s companies corporations and markets are all about people and relationships and IT Managers should follow the trend Just be sure you and your team are actually producing the kind of quality work you would like to receive recognition for Yours the IT Guy Labels Musings Email This BlogThis Share to Twitter Share to Facebook 3 comments RichBos June 7 2011 at 11 06 AM My world as it is now the world of flexible co working spaces web freelancers hosting platforms and dynamic solutions couldn t be more different from the corporate network I enjoyed for all those years The freedom is liberating and it s refreshing to be able to discuss a clients requirement in the morning search for a solution and implement it by close of play the same day in some cases It can have it s moments though and when you find yourself at the cutting edge of the latest technology which happens a lot more it certainly pushes the grey matter into action But appreciated Yes much more mainly because you re no longer fighting against policy and can actually deliver something quickly which is not only welcome it s needed If the free world had to adhere to the same restrictions as the Enterprise I doubt we d even have an internet Don t get me wrong as an ITIL guy I fully understand the need for policy across a corporate platform I m just happy I don t have to enforce it anymore Being dynamic has its moments but it s a lot more fun Reply Delete the ITGuy June 7 2011 at 5 51 PM Working as a freelancer sure has more advantages than not provided you have a healthy and sustainable client base Thinking back to my own freelancing days the beauty of freedom was freequently besmirched by the mundane tasks writting up offers negotiating re negotiating and re re negotiating prices accounting and the lot Despite the above marketing and self promotion surely are a big part of freelancing where every new project depends on a previous happy customer Do you think that appreciation in a corporate environment can be at all influenced and regulated Is it a lost cause Or perhaps not worth the effort Reply Delete RichBos June 8 2011 at 1 05 PM Yes I can see how that would spoil things however I use shared co working space in Leeds city centre which is simply wonderful and has pulled work without me having to even leave the building for me it s without a doubt the way forward and delivers multiple benefits aside from the free coffee I honestly can t recommend it enough In a corporate environment though I would say yes appreciation can always be boosted and personality drive can carry

    Original URL path: http://www.itguy.gr/2011/06/im-it-manager-nobody-loves-me.html (2016-01-31)
    Open archived version from archive

  • ...from punch cards to high up in the cloud!: Workaround for Citrix EdgeSight Process Usage report showing average times instead of time sums and a quick insight into using MS SQL Report Builder with queries to generate custom SQL reports
    nVarChar 4000 ReplaceColumnName DataToFind Set DataExists 1 Else Set DataExists 0 ELSE If Exists Select From ReplaceTableName Where Convert nVarChar 4000 ReplaceColumnName Like DataToFind Set DataExists 1 Else Set DataExists 0 END PARAMETERS DataExists Bit OUTPUT i 1 SELECT i 1 MAX MAX RowId FROM Temp WHILE i MAX BEGIN SELECT SQL REPLACE REPLACE SQLTemplate ReplaceTableName QUOTENAME SchemaName QUOTENAME TableName ReplaceColumnName ColumnName FROM Temp WHERE RowId i PRINT SQL EXEC SP EXECUTESQL SQL PARAMETERS DataExists DataExists OUTPUT IF DataExists 1 UPDATE Temp SET DataFound 1 WHERE RowId i SET i i 1 END SELECT SchemaName TableName ColumnName FROM Temp WHERE DataFound 1 GO So execute this as a query on the CitrixSmartAuditor database then execute the following query Exec FindMyData string e4e0d818 63ff 41c1 ab7b 6a58985e13b2 0 Struck gold That File ID is the actual recorded video file name and it exists on the FilePath column of the ICLFile table The same table holds almost all info we require such as StartTime and EndTime and Duration There is ony one last piece of info needed to stitch everything together the username So let s look inside the CitrixSmartAuditor database for columns that include name in their name USE CitrixSmartAuditor GO SELECT t name AS table name SCHEMA NAME schema id AS schema name c name AS column name FROM sys tables AS t INNER JOIN sys columns c ON t OBJECT ID c OBJECT ID WHERE c name LIKE name ORDER BY schema name table name Down at the bottom is a table UserAccount with a column name Name which looks like the one we re looking A quick view at the table contents confirms that the column Name actually holds the username records Now all that s needed is a common link between the two tables I m guessing that UserAccountID from ICLFile and ID from UserAccount are the most likely candidates so let s confirm this hypothesis select distinct UserAccountID from dbo ICLFile select distinct ID from dbo UserAccount We now have proof that the two tables are linked so we have all the information we need to form our query To formulate and test the query we will use some set values which later at the Report Builder stage will become variables These values are StartTime 2011 06 02 00 00 00 000 EndTime 2011 06 02 23 59 59 000 UserName 0011234 So this is the query SUM DURATION from dbo ICLFile where StartTime 2011 06 02 00 00 00 000 and EndTime 2011 06 02 23 59 59 000 and UserAccountID in select ID from dbo UserAccount where Name 0011234 select StartTime EndTime filepath Duration from dbo ICLFile where StartTime 2011 06 02 00 00 00 000 and EndTime 2011 06 02 23 59 59 000 and UserAccountID in select ID from dbo UserAccount where Name 0011234 order by StartTime And these are the results Which is exactly what we need The total duration in seconds the individual sessions with start end time recorded video

    Original URL path: http://www.itguy.gr/2011/06/workaround-for-citrix-edgesight-process.html?showComment=1406005051800 (2016-01-31)
    Open archived version from archive

  • ...from punch cards to high up in the cloud!: Annoying "You cannot access VMM management server scvmm.domain.local" 1604 error: "Contact the Virtual Machine Manager administrator to verify that your account is a member of a valid user role and then try the operation again."
    of fact I think I ve always used the domain admin to install SCVMM and a different account for the service But I ll test it nonetheless Mind you though that uninstalling and reinstalling anything cannot qualify as a fix Furthermore as you can see here http technet microsoft com en us library gg697600 aspx there is no mention that the service account should only be used to run the service What it does mention is that the domain account should be made part of the Local Admins group This grants the account full access to the machine and installing any application should not pose a problem Also the PowerShell console opens fine from within the SCVMM console This will remain a bug in my book until proven otherwise Reply Delete Joshua June 24 2013 at 11 48 PM Thanks Saved me so much grief on this one Reply Delete Anonymous June 27 2013 at 3 03 AM Thanks for the help this bug still exists in SP1 Reply Delete Anonymous July 19 2013 at 9 05 PM The UI tells you to login with credentials formatted as DOMAIN Username This fix works perfectly login with just Username but why is this even a bug If this is a feature as another anonymous comment suggested why would they not update the UI to reflect this Even a small warning would ve been nice Regardless this is a great post and I am glad it helped me out Reply Delete test September 3 2013 at 2 05 PM hahaha thanks a lot Reply Delete Anonymous October 1 2013 at 3 18 PM OMFG and it actually even asks for a domain username in the GUI Reply Delete Anonymous October 16 2013 at 7 23 PM Saved me hours of research Thanks Reply Delete Anonymous October 31 2013 at 5 12 PM Thank you for this Saved me from going completely stir crazy Reply Delete Anonymous January 24 2014 at 7 59 AM It worked on a fresh install of Windows System Center 2012 R2 VMM I couldn t log in and tried your method and voila it works Reply Delete Anonymous July 28 2014 at 6 34 PM Thenk you Reply Delete Mark Harrington August 12 2014 at 10 12 AM Thank you This has saved a lot of frustration Although I still have a fair bit as I cant get the install to work on a machine that has had an older VMM console installed on it I have even uninstalled the old version but the 2012 install says there are still VMM components installed and only allows you to remove components Reply Delete Anonymous December 15 2014 at 10 36 AM Hi mate you wrote this article three years ago and it is STILL helpful to this day I ve wasted a day trying to log into a demo VMM environment and your solution finally got me in This is a truly RIDICULOUS bug to contend with Thanks for

    Original URL path: http://www.itguy.gr/2011/12/anoying-you-cannot-access-vmm.html?showComment=1335440347489 (2016-01-31)
    Open archived version from archive

  • ...from punch cards to high up in the cloud!: Annoying "You cannot access VMM management server scvmm.domain.local" 1604 error: "Contact the Virtual Machine Manager administrator to verify that your account is a member of a valid user role and then try the operation again."
    of fact I think I ve always used the domain admin to install SCVMM and a different account for the service But I ll test it nonetheless Mind you though that uninstalling and reinstalling anything cannot qualify as a fix Furthermore as you can see here http technet microsoft com en us library gg697600 aspx there is no mention that the service account should only be used to run the service What it does mention is that the domain account should be made part of the Local Admins group This grants the account full access to the machine and installing any application should not pose a problem Also the PowerShell console opens fine from within the SCVMM console This will remain a bug in my book until proven otherwise Reply Delete Joshua June 24 2013 at 11 48 PM Thanks Saved me so much grief on this one Reply Delete Anonymous June 27 2013 at 3 03 AM Thanks for the help this bug still exists in SP1 Reply Delete Anonymous July 19 2013 at 9 05 PM The UI tells you to login with credentials formatted as DOMAIN Username This fix works perfectly login with just Username but why is this even a bug If this is a feature as another anonymous comment suggested why would they not update the UI to reflect this Even a small warning would ve been nice Regardless this is a great post and I am glad it helped me out Reply Delete test September 3 2013 at 2 05 PM hahaha thanks a lot Reply Delete Anonymous October 1 2013 at 3 18 PM OMFG and it actually even asks for a domain username in the GUI Reply Delete Anonymous October 16 2013 at 7 23 PM Saved me hours of research Thanks Reply Delete Anonymous October 31 2013 at 5 12 PM Thank you for this Saved me from going completely stir crazy Reply Delete Anonymous January 24 2014 at 7 59 AM It worked on a fresh install of Windows System Center 2012 R2 VMM I couldn t log in and tried your method and voila it works Reply Delete Anonymous July 28 2014 at 6 34 PM Thenk you Reply Delete Mark Harrington August 12 2014 at 10 12 AM Thank you This has saved a lot of frustration Although I still have a fair bit as I cant get the install to work on a machine that has had an older VMM console installed on it I have even uninstalled the old version but the 2012 install says there are still VMM components installed and only allows you to remove components Reply Delete Anonymous December 15 2014 at 10 36 AM Hi mate you wrote this article three years ago and it is STILL helpful to this day I ve wasted a day trying to log into a demo VMM environment and your solution finally got me in This is a truly RIDICULOUS bug to contend with Thanks for

    Original URL path: http://www.itguy.gr/2011/12/anoying-you-cannot-access-vmm.html?showComment=1335445183485 (2016-01-31)
    Open archived version from archive

  • ...from punch cards to high up in the cloud!: Annoying "You cannot access VMM management server scvmm.domain.local" 1604 error: "Contact the Virtual Machine Manager administrator to verify that your account is a member of a valid user role and then try the operation again."
    of fact I think I ve always used the domain admin to install SCVMM and a different account for the service But I ll test it nonetheless Mind you though that uninstalling and reinstalling anything cannot qualify as a fix Furthermore as you can see here http technet microsoft com en us library gg697600 aspx there is no mention that the service account should only be used to run the service What it does mention is that the domain account should be made part of the Local Admins group This grants the account full access to the machine and installing any application should not pose a problem Also the PowerShell console opens fine from within the SCVMM console This will remain a bug in my book until proven otherwise Reply Delete Joshua June 24 2013 at 11 48 PM Thanks Saved me so much grief on this one Reply Delete Anonymous June 27 2013 at 3 03 AM Thanks for the help this bug still exists in SP1 Reply Delete Anonymous July 19 2013 at 9 05 PM The UI tells you to login with credentials formatted as DOMAIN Username This fix works perfectly login with just Username but why is this even a bug If this is a feature as another anonymous comment suggested why would they not update the UI to reflect this Even a small warning would ve been nice Regardless this is a great post and I am glad it helped me out Reply Delete test September 3 2013 at 2 05 PM hahaha thanks a lot Reply Delete Anonymous October 1 2013 at 3 18 PM OMFG and it actually even asks for a domain username in the GUI Reply Delete Anonymous October 16 2013 at 7 23 PM Saved me hours of research Thanks Reply Delete Anonymous October 31 2013 at 5 12 PM Thank you for this Saved me from going completely stir crazy Reply Delete Anonymous January 24 2014 at 7 59 AM It worked on a fresh install of Windows System Center 2012 R2 VMM I couldn t log in and tried your method and voila it works Reply Delete Anonymous July 28 2014 at 6 34 PM Thenk you Reply Delete Mark Harrington August 12 2014 at 10 12 AM Thank you This has saved a lot of frustration Although I still have a fair bit as I cant get the install to work on a machine that has had an older VMM console installed on it I have even uninstalled the old version but the 2012 install says there are still VMM components installed and only allows you to remove components Reply Delete Anonymous December 15 2014 at 10 36 AM Hi mate you wrote this article three years ago and it is STILL helpful to this day I ve wasted a day trying to log into a demo VMM environment and your solution finally got me in This is a truly RIDICULOUS bug to contend with Thanks for

    Original URL path: http://www.itguy.gr/2011/12/anoying-you-cannot-access-vmm.html?showComment=1337667649128 (2016-01-31)
    Open archived version from archive



  •