SharePoint File Size Field is a Lookup

So I have some code that is querying a document library and based on the on the field type I do some casting to get the field value. I.E. If its a lookup field, I want the value, not the crazy internal "ID;#Value" to be returned. So this works just fine, but we just had to add the "File Size" field to be returned - seems easy, but the File Size was always coming back as empty.

After some debugging it seems if you have the SPListItem of the document, lets say "item" is the variable doing the following:

item.Fields["File Size"].Type

returns "Lookup". Even more if you cast it to a lookup field, it sets the LookupId field to the file size and the LookupValue to be empty.

Anyone know a way around this or see something I'm not seeing. I need to be able to parse the fields based on their type, and would like to not have to put in a hard code to check if its the "File Size" field to return the LookupId instead of hte LookupValue

Thanks!

-Tyler

Edited by Tyler W Lamb Thursday, March 1, 2012 11:20 PM

Reply:

You could add a check for the # delimiter that lookup values use to seperate the id and the value. The # delimiter needs to be in the value before you can cast the object to a SPFieldLookupValue. You can assume that you only have the value when the # delimiter is not present.

SharePoint Developer | @zeemanj | Blog

------------------------------------
Reply:

I supposed that would work - but I'm almost just curious now as to why that field is a Lookup field

-Tyler

------------------------------------

Nvidia 250gts 1GB freezing (more like long pauses) & also graphical anomalies in Firefox

Edit:

Problem 1, drivers supplies with Win8 customer preview had caused a lot of freezing / pausing possibly to do with charms(?).

Problem 2, Nvidia 296.73 windows 8 preview drivers cause anomalies with Firefox or vice versa. Disabling hardware acceleration in Firefox appears to fix.

Just noting that that drivers supplies with Win8 customer preview had caused a lot of freezing / pausing. It might have something to do with the charms but installing 296.73 windows 8 drivers from nvidia fixes it however...

The 296.74 drivers include graphical anomalies at times. Unknown to me what causes them atm.

asus amd mobo
amd xII x4 945
4GB ram
60GB ocz ssd
nvidia 250 gts 1GB

Edited by North7 Thursday, March 1, 2012 11:46 PM

Reply:

"looks like your video card has problems with VRAM overheating"

Doubtful, unless the drivers are doing it.

Also doubtful as I just turned on the PC and there's some anomalies already (the video card is still warming up).

Also doubtful as it appears to always occur in the exact same places like for instance on the home & favorite buttons in firefox.

Also doubtful as they go away for a while.

Also doubtful as it didn't do that with the supplied driver of Win8 preview nor with win7.

Its most likely an issue with the latest nvidia drivers.

But, because the supplied drivers in Win8 are worse, its more of a note to devs that there's a problem that needs fixing.

And I don't overclock so that's that.

Edited by North7 Thursday, March 1, 2012 5:49 PM

------------------------------------
Reply:

The inbox drivers are always not recommomend. AMD released new Windows 8 drivers today so wait for nVIDIA Win8 drivers.

"A programmer is just a tool which converts caffeine into code"

------------------------------------
Reply:

so wait for nVIDIA Win8 drivers.

Already using Nvidia win8 preview drivers. They were out when the preview hit the web.

------------------------------------
Reply:

ok :) I'm an AMD user so I don't know if nVIDIA released drivers.

"A programmer is just a tool which converts caffeine into code"

------------------------------------
Reply:

No problem, a lot of people don't seem to know ;)

Even on news sites, I've only seen announcements for AMD drivers not Nvidia.

------------------------------------
Reply:

I am using NVIDIA and my GTX 260 seems to be OK at the moment

Oh, I just tried something, since I spend a lot of time with Firefox open, disabled the hardware acceleration for Firefox and that might have done it - need more time.

Didn't think about it not occurring outside of Firefox till now.

So the drivers have a problem with Firefox or Firefox has a problem with the drivers.

Overall, the Nvidia preview drivers seem very stable. Played HL2-EP2 for more than an hour and it was molto bene.

------------------------------------
Reply:

I suggest using IE for the moment until everyone updates their software as required.

Aren't we supposed to be testing? ;)

Breaking things is therefore a must.

Anyways, while that is good advice, Firefox appears to work perfect now. Hardware acceleration isn't needed here, but for those who need it, then they should use IE like you say - though even then Firefox worked fine with the anomalies. They weren't that bad.

Edited by North7 Thursday, March 1, 2012 11:31 PM

------------------------------------
Reply:

check on GeForce.com for new drivers, I do daily

Actually, geforce.com didn't show the Win8 preview drivers yesterday when nvidia.com had them.

I've never adjusted to going to geforce.com for the drivers and can't understand why they did that. The main site is better imo.

Edited by North7 Thursday, March 1, 2012 11:42 PM

------------------------------------

Change History

I can poll subscription views to find the last change dates of a row in a model.

How do I get the complete history of / previous change dates of rows in mds. That is: all changes starting since EnterDate Time.

Regards AB

Changed type Ed Price - MSFTMicrosoft employee Tuesday, December 23, 2014 10:37 PM

SharePoint 2010 Unit Testing using Pex and Moles

Hi,

Has anyone used Pex and Moles for unit testing SharePoint 2010 projects

http://research.microsoft.com/en-us/projects/pex/documentation.aspx

If so can you please share your experience with this.

Thanks

Arjuna.

Reply:

Very helpful for unit testing with SharePoint 2010. We have started using this for all our projects.

You can have a look at a strater video from MSDN.

http://channel9.msdn.com/blogs/matthijs/pex-unit-testing-of-sharepoint-services-that-rocks

Varun Malhotra
=================
If my post solves your problem could you mark the post as Answered or Vote As Helpful if my post has been helpful for you.

------------------------------------

Error on upgrading the AZURE SDK

Error on Upgrading AZURE SDK.

An error occurred creating the configuration section handler for system.serviceModel/extensions: Could not load file or assembly 'Microsoft.ServiceBus, Version=1.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 170)

Reason:

When you installed Azure SDK 1.5 and AppFabric some details will be noted down in your MACHINE.CONFIG file of your .net Framework.

Like in C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config.

You can find the details of Microsoft.ServiceBus dll details over here like its version is 1.5.X.X.

After this, when you uninstall sdk 1.5 and go for 1.6 or some other version, earlier details of Microsoft.ServiceBus dll will not be overwritten with new details.

And now, if you refer to Microsoft.ServiceBus dll of 1.6 version in your application, both will be conflicting and this is the reason for your error.

WorkAround :

So, Please update the entries of dll versions in your machine config accordingly for smooth run.

Hope, this would help you...

Mahesh Jasti

Reply:

Hi,

I have the same problem, and your workaround helped me! Thanks!

------------------------------------
Reply:

Hi,

I'm need to Azure development and have only installed v1.6 on my machine in order to go through the Echo tutorial. I'm getting this same error which really confuses me since I didn't have a previous version on this machine.

I did download the install files to my system and manually install; following the instructions on the download site.

I'd appreciate your help understanding how this conflict can occur on a clean install.

Thanks!

Thanks, KBW

------------------------------------
Reply:

Sorry, mine was a self-inflicted "copy and paste" problem. I've corrected it in my app.config file...

I'll leave this post just in case there are other knuckle-heads out there lime me :)

Thanks, KBW

Edited by KWeeks Thursday, March 1, 2012 9:48 PM

------------------------------------

Windows Azure Management Portal not working,

Hello,

The Windows Azure Management Portal is down since more than 2 hours.

Can anyone please let me know when it will be up and running. I have some urgent uploads to be done.

The website links that I used is http://windows.azure.com/ to log into the management portal, from India.

Regards

Sandeep Kenkare

Changed type Arwind - MSFT Friday, March 9, 2012 9:49 AM

Reply:

Same here, and it's been over 10 hours since I was able to successfully deploy something. This is a complete and utter disaster. Service dashboard https://www.windowsazure.com/en-us/support/service-dashboard/ says there is a hotfix rollout that is in progress...

------------------------------------
Reply:

Same here, Trying to connect for several hours now.

Trying from the lowlands, should be a general portal though looking at the dashboard. But the dash doesn't show any errors on the management portal. We are losing development hours. When will this be fixed ?

------------------------------------
Reply:

My company's website's have been down for the last hour (since approx 11am GMT). This is causing quite a problem for us as we accept online payment 24-7 across the UK and Europe.

The service dashboard isn't telling me anything outside of what I already know, except it's saying "Deployed applications will continue to run." - I can tell you this isn't true as the deployed applications aren't responding. Our applications are deployed in the Northern Ireland datacenter.

https://www.microsoft.com/windowsazure/support/status/RSSFeed.aspx?RSSFeedCode=WACNE

Come on Microsoft.

Edited by Bernie Cook (RSL) Wednesday, February 29, 2012 12:27 PM Typo

------------------------------------
Reply:

Yes, the portal is down. You can check out the updated status at the service dashboard: http://www.windowsazure.com/en-us/support/service-dashboard/

If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Thanks! Vaibhav Gujral.

------------------------------------
Reply:

An outage of this length and breadth is completely unacceptable. Heads need to roll after this is resolved.

------------------------------------
Reply:

It appears to be connected to leap year, if you look at when the outage started and is continuing. The MOTD indicates:

"..4:00 AM UTC We have identified the root cause of this incident. It has been traced back to a cert issue triggered on 2/29/2012 GMT..."

------------------------------------
Reply:

Hi,

The Windows Azure Management Portal is available now.

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact msdnmg@microsoft.com Microsoft One Code Framework

------------------------------------
Reply:

Hi,

The portal is down again...

I have an error message on windows.azure.com after login.

Edit : I successfully load the silverlight but i got a timeout and cannot view my host services or other informations.

Edited by PMartos Thursday, March 1, 2012 9:36 PM

------------------------------------

OMG, FAST!!

Just felt like sharing this observation...

Yep, Win7 is lots quicker than Vista but...

OMG, is Windows 8 ever fast & snappy!! Internal or Net... fun trying to mouse fast enough to keep up w/ it (I say that just to help get the point across, truly it's quite manageable, I'm coping nicely, lol)

I kinda of expected this. Hadn't leaned to heavily on the DP & I had it running as a VM, but, still... Now running the Win8 Beta as a dual-boot w/ my Win7 & WOW, is the Win8 ever a speedy little bugger!!

And, once a person finds the stuff, some of the nav tools, on the Desktop, are pretty funky (that means good, btw) and great to have... saves going to Start Screen (1st); this & many other things were not, I don't believe, in the DP. I'm finding the Beta a huge stride from what the DP was. Some suggested that wouldn't be the case, I expected it & feel I'm seeing, indeed, just that.

Nice having Spell Check everywhere w/ IE10, too.

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

Edited by Drew1903 Thursday, March 1, 2012 8:07 PM

PowerShell 3.0 IS 'Beta'

http://www.microsoft.com/download/en/details.aspx?id=28998

¯\_(ツ)_/¯

Changed type jrv Thursday, March 1, 2012 6:02 PM

Reply:

Cool, great news. I have been waiting for the next version to come out.

------------------------------------
Reply:

Installing it now. Waiting to see if booleans still have a .todatetime() method.

They do! Now, if I can just figure out what the heck you use that for, and how.

[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

Edited by mjolinor Thursday, March 1, 2012 7:09 PM

------------------------------------

Keeping track of multiple statuses and their history

I have designed the following database for a small project. Please review and leave feedback. The main problem i'm having is to keep tracking of many statuses. The user wants to know the status of particular action on a given date. Do I have to create seperate table for just statuses with date added, date modified etc?

Edited by jonnagaddala Friday, February 17, 2012 4:59 AM

Reply:

First critique. There are no explanations other than "small project". :)

Second, naming is inconsistant. Docs, or doctors, for example.

Third, why the word "set". This is annoying, the TABLEs are named in plural and have the word "set" on them?!?!

Naming aside, a bit of explanation would go a long way.

Edited by Brian TkatchEditor Thursday, February 16, 2012 1:40 PM

------------------------------------
Reply:

Yep it is a small project.

Fixed the namings.

I'm using lightswitch, the word set is added to tables by default.

Any idea on different statuses ? What is the best way to keep track of statuses with history and date ?

------------------------------------
Reply:

Hi,

There are few observations as based on your DB design,

1. Try to give detailed names for the tables/colums unless if any word is a business term. And maintain consistency on the same across all tables.

2. Separate data/attibutes into master and detail tables.

example: DoctorsMaster --with non repeatable data attributes(Name, Registration number, etc) and

DocterDetails -- Address, email, phone numbers etc

DoctorsMaster , PatientsMaster, HospitalMaster etc. can be made as master tables as per my opinion.

3. The relationship between DoctersHospitalsSet, DocsAddresses, DoctorsSet found to be a deadlock/looping situation. Avoid such relationships and restructure it. You can make use of map/bridge tables if necessary.

4. If one patient can have multiple statuses. Create a Master table of different statuses. Make foreign key in main/transaction table. Thus if you want to add a new status for a patient that can be accomodated very easily. Following can be transaction table for maintaining multiple statuses for each patient.

PatientId

StatuID

Date

Thanks,

Suresh

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

------------------------------------
Reply:

Suresh,

Thank you so much for your tips. I have implemented them and this is latest version. But I couldn't come up with a better way to map for your 3rd point. Each doctor works for multiple hospitals and this doctor has obviouslu different address at each hospital.

When you are free please have a look at our codeplex project to understand our requirements. I just want to make sure I haven't missed out anything.

Edited by jonnagaddala Friday, February 17, 2012 9:26 AM

------------------------------------
Reply:

Hi,

Please see below, this may be helpful for your design.

Thanks,
Suresh
Please use Mark or Propose as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

------------------------------------
Reply:

Some simple questions

1.Can a person be a doctor and also a patient ?

2.How XXMaster and XXDetails are different?

Serg

------------------------------------
Reply:

SvgSuresh,

Thanks for the posting. I will revise accordingly. I'm printing a letter in my application to send it to Doctor. Since each doctor has multiple addresses. I'm not able to keep track to which address I should send. Guess, I have to link the HospitalAddress to Patients too ?

SergNL,

Honestly that's a good point. I would really love to see how can we handle if person can be both doctor or patient ? Create a table with Person and Person type ?

------------------------------------
Reply:

Hi,

Answer to Q1:

If a person can be both Doctor as well as Patient, in that case there will be a record in both PatientsMaster and DoctorsMaster table. As these two are differents records. But, there will be a drawback, if you have such record in Patient associates to its own id(doctor).

Answer to Q2:

As per your explaination, I guess, a doctor is associated to a hospital by his address and not with his ID(license#). In such case you can change the relationship in DoctorHospitalMap table. Instead of DoctorsId put DoctorsDetailId, that way you can get all the details.

i.e. Hospital, associated doctor and his patient or vice versa. Please refer the sample below,

Hope it helps.

Thanks,
Suresh
Please use Mark or Propose as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

------------------------------------
Reply:

Yes, I'd suggested having Person entity for most common data such as Name, Birthday, Sex which do not depend on the roles the person plays. Doctor and Patient are subtypes of Person.

Serg

------------------------------------

Does zipping project files to email increase the chances of file corruption?

Just wondered if anyone could advise if zipping project files to email them increase the chances of file corruption?

Thanks Steve

Reply:

I would think that zipping them decreases the chance becuase if on the receiving end they are "unzippable", then the file was probably transferred correctly.

While in today's world we take for granted the ability to "send a file", it's an incredibly complex process and the designers of the Internet did wonderous things in designing that functionality.

--rms www.rmschneider.com

Edited by Rob Schneider Tuesday, February 7, 2012 7:25 PM

------------------------------------
Reply:

I would agree that zipping will have little chance of increasing the chances of issues - most problems i have seen come from different versions o Project, a PC not powerful enough to run project or plain unlucky chance.

HTH

Miles

------------------------------------
Reply:

Oh no i just noticed i have reported this as abuse (by accident) im so sorry MilesS2111S. I hope i havent got you into trouble! Does any one know how i remove this action?

------------------------------------
Reply:

IMO, I guess the moderators have already noticed that it was by accident so no problem.

Edited by Ismet Kocaman Thursday, March 1, 2012 5:54 PM

------------------------------------
Reply:

>> Just wondered if anyone could advise if zipping project files to email them increase the chances of file corruption?

It may happen. I would suggest you use a checksum verifier.

------------------------------------

Example of a localized XML-MP

Hi All !

Travis posted a MP to view "All activites related to me".

http://blogs.technet.com/b/servicemanager/archive/2010/09/28/all-work-items-assigned-to-me-view.aspx

I needed to localize it to German for a customer and want to share the result with you.

Have fun using it - Roman

<ManagementPack ContentReadable="true" SchemaVersion="1.1" OriginalSchemaVersion="1.1" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">   <Manifest>   <Identity>   <ID>WorkItemsAssignedToMeDEU</ID>   <Version>1.0.0.0</Version>   </Identity>   <Name>Work Items Assigned To Me DEUTSCH</Name>   <References>   <Reference Alias="Console">   <ID>Microsoft.EnterpriseManagement.ServiceManager.UI.Console</ID>   <Version>7.0.5826.886</Version>   <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>   </Reference>   <Reference Alias="WorkItem">   <ID>System.WorkItem.Library</ID>   <Version>7.0.5826.0</Version>   <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>   </Reference>   <Reference Alias="Authoring">   <ID>Microsoft.EnterpriseManagement.ServiceManager.UI.Authoring</ID>   <Version>7.0.5826.0</Version>   <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>   </Reference>   <Reference Alias="CoreKnowledge">   <ID>System.Knowledge.Library</ID>   <Version>7.0.5826.0</Version>   <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>   </Reference>   <Reference Alias="IncidentManagement">   <ID>ServiceManager.IncidentManagement.Library</ID>   <Version>7.0.5826.0</Version>   <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>   </Reference>   <Reference Alias="SupportingItem">   <ID>System.SupportingItem.Library</ID>   <Version>7.0.5826.0</Version>   <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>   </Reference>   <Reference Alias="SystemActivityLibrary">   <ID>System.WorkItem.Activity.Library</ID>   <Version>7.0.5826.0</Version>   <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>   </Reference>   <Reference Alias="System">   <ID>System.Library</ID>   <Version>7.0.5826.0</Version>   <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>   </Reference>   <Reference Alias="ServiceManagerWorkItem">   <ID>ServiceManager.WorkItem.Library</ID>   <Version>7.0.5826.0</Version>   <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>   </Reference>   </References>   </Manifest>   <TypeDefinitions>   <EntityTypes>   <TypeProjections>   <TypeProjection ID="System.WorkItem.AssignedToUser.Projection" Accessibility="Public" Type="WorkItem!System.WorkItem">   <Component Path="$Target/Path[Relationship='WorkItem!System.WorkItemAssignedToUser']$" Alias="WorkItemAssignedToUser" />   <Component Path="$Target/Path[Relationship='SystemActivityLibrary!System.WorkItemContainsActivity' TypeConstraint='SystemActivityLibrary!System.WorkItem.Activity.ReviewActivity']$" Alias="ContainedReviewActivities">   <Component Path="$Target/Path[Relationship='SystemActivityLibrary!System.ReviewActivityHasReviewer']$" Alias="Reviewers">   <Component Path="$Target/Path[Relationship='SystemActivityLibrary!System.ReviewerIsUser']$" Alias="User" />   </Component>   </Component>   </TypeProjection>   </TypeProjections>   </EntityTypes>   </TypeDefinitions>   <Categories>   <Category ID="WorkItemMPCategory" Value="Console!Microsoft.EnterpriseManagement.ServiceManager.ManagementPack">   <ManagementPackName>WorkItemsAssignedToMeDEU</ManagementPackName>   <ManagementPackVersion>1.0.0.0</ManagementPackVersion>   </Category>   <Category ID="Category.fd56a9047f8643c2affd29e363389a33" Target="View.WorkItemsAssignedToMeDEU" Value="Console!Microsoft.EnterpriseManagement.ServiceManager.UI.Console.ViewTasks" />   <Category ID="Category.9b1fd548772c49b7b13423020f8ad7f3" Target="View.WorkItemsAssignedToMeDEU" Value="Authoring!Microsoft.EnterpriseManagement.ServiceManager.UI.Authoring.CreateTypeCategory" />   </Categories>   <Presentation>   <Views>   <View ID="View.WorkItemsAssignedToMeDEU" Accessibility="Public" Enabled="true" Target="WorkItem!System.WorkItem" TypeID="Console!GridViewType" Visible="true">   <Category>NotUsed</Category>   <Data>   <Adapters>   <Adapter AdapterName="dataportal:EnterpriseManagementObjectProjectionAdapter">   <AdapterAssembly>Microsoft.EnterpriseManagement.UI.SdkDataAccess</AdapterAssembly>   <AdapterType>Microsoft.EnterpriseManagement.UI.SdkDataAccess.DataAdapters.EnterpriseManagementObjectProjectionAdapter</AdapterType>   </Adapter>   <Adapter AdapterName="viewframework://Adapters/AdvancedList">   <AdapterAssembly>Microsoft.EnterpriseManagement.UI.ViewFramework</AdapterAssembly>   <AdapterType>Microsoft.EnterpriseManagement.UI.ViewFramework.AdvancedListSupportAdapter</AdapterType>   </Adapter>   </Adapters>   <ItemsSource>   <AdvancedListSupportClass DataTypeName="" AdapterName="viewframework://Adapters/AdvancedList" FullUpdateAdapter="dataportal:EnterpriseManagementObjectProjectionAdapter" RemoveItemsAdapter="dataportal:EnterpriseManagementObjectProjectionAdapter" AppendItemsAdapter="dataportal:EnterpriseManagementObjectProjectionAdapter" UpdateItemsAdapter="dataportal:EnterpriseManagementObjectProjectionAdapter" DataSource="mom:ManagementGroup" FullUpdateFrequency="1" Streaming="true" IsRecurring="true" RecurrenceFrequency="{x:Static s:Int32.MaxValue}" xmlns="clr-namespace:Microsoft.EnterpriseManagement.UI.ViewFramework;assembly=Microsoft.EnterpriseManagement.UI.ViewFramework" xmlns:av="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:s="clr-namespace:System;assembly=mscorlib">   <AdvancedListSupportClass.Parameters>   <QueryParameter Parameter="TypeProjectionId" Value="$MPElement[Name='System.WorkItem.AssignedToUser.Projection']$" />   </AdvancedListSupportClass.Parameters>   </AdvancedListSupportClass>   </ItemsSource>   <Criteria>   <QueryCriteria Adapter="omsdk://Adapters/Criteria" xmlns="http://tempuri.org/Criteria.xsd">   <Criteria>   <FreeformCriteria>   <Freeform>   <Criteria xmlns="http://Microsoft.EnterpriseManagement.Core.Criteria/">   <Expression>   <Or>   <Expression>   <SimpleExpression>   <ValueExpressionLeft>   <GenericProperty Path="$Context/Path[Relationship='WorkItem!System.WorkItemAssignedToUser']$">Id</GenericProperty>   </ValueExpressionLeft>   <Operator>Equal</Operator>   <ValueExpressionRight>   <Token>[me]</Token>   </ValueExpressionRight>   </SimpleExpression>   </Expression>   <Expression>   <SimpleExpression>   <ValueExpressionLeft>   <GenericProperty Path="$Context/Path[Relationship='SystemActivityLibrary!System.WorkItemContainsActivity']/Path[Relationship='SystemActivityLibrary!System.ReviewActivityHasReviewer']/Path[Relationship='SystemActivityLibrary!System.ReviewerIsUser']$">Id</GenericProperty>   </ValueExpressionLeft>   <Operator>Equal</Operator>   <ValueExpressionRight>   <Token>[me]</Token>   </ValueExpressionRight>   </SimpleExpression>   </Expression>   </Or>   </Expression>   </Criteria>   </Freeform>   </FreeformCriteria>   </Criteria>   </QueryCriteria>   </Criteria>   </Data>   <Presentation>   <Columns>   <mux:ColumnCollection xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:mux="http://schemas.microsoft.com/SystemCenter/Common/UI/Views/GridView" xmlns:s="clr-namespace:System;assembly=mscorlib" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:data="clr-namespace:Microsoft.EnterpriseManagement.UI.SdkDataAccess.Common;assembly=Microsoft.EnterpriseManagement.UI.SdkDataAccess">   <mux:Column Name="Id" DisplayMemberBinding="{Binding Path=Id}" Width="100" DisplayName="Id.3a604d3142fa4ce3bab913e5a036e18a" Property="Id" DataType="s:String" />   <mux:Column Name="Title" DisplayMemberBinding="{Binding Path=Title}" Width="100" DisplayName="Title.a3f6dcad2ecf4a609b68c16c58f81602" Property="Title" DataType="s:String" />   <mux:Column Name="Description" DisplayMemberBinding="{Binding Path=Description}" Width="100" DisplayName="Description.f075b2ab8d9f4a6eacdcb7eff2d1eef7" Property="Description" DataType="s:String" />   <mux:Column Name="CreatedDate" DisplayMemberBinding="{Binding Path=CreatedDate}" Width="100" DisplayName="CreatedDate.739810e72b5145558c9f07a1b96def84" Property="CreatedDate" DataType="s:DateTime" />   <mux:Column Name="$LastModified$" DisplayMemberBinding="{Binding Path=$LastModified$}" Width="100" DisplayName="LastModified.985256ae2873442581403e96820ddf3b" Property="$LastModified$" DataType="s:DateTime" />   </mux:ColumnCollection>   </Columns>   <ViewStrings>   <ViewString ID="CreatedDate.739810e72b5145558c9f07a1b96def84">$MPElement[Name="CreatedDate.739810e72b5145558c9f07a1b96def84"]$</ViewString>   <ViewString ID="Description.f075b2ab8d9f4a6eacdcb7eff2d1eef7">$MPElement[Name="Description.f075b2ab8d9f4a6eacdcb7eff2d1eef7"]$</ViewString>   <ViewString ID="Id.3a604d3142fa4ce3bab913e5a036e18a">$MPElement[Name="Id.3a604d3142fa4ce3bab913e5a036e18a"]$</ViewString>   <ViewString ID="LastModified.985256ae2873442581403e96820ddf3b">$MPElement[Name="LastModified.985256ae2873442581403e96820ddf3b"]$</ViewString>   <ViewString ID="Title.a3f6dcad2ecf4a609b68c16c58f81602">$MPElement[Name="Title.a3f6dcad2ecf4a609b68c16c58f81602"]$</ViewString>   </ViewStrings>   </Presentation>   </View>   </Views>   <FolderItems>   <FolderItem ElementID="View.WorkItemsAssignedToMeDEU" ID="FolderItem.eaede5edadfd4d8b9154f751b35ae1d0" Folder="ServiceManagerWorkItem!ServiceManager.Console.WorkItem.Root" />   </FolderItems>   <ImageReferences>   <ImageReference ElementID="View.WorkItemsAssignedToMeDEU" ImageID="ServiceManagerWorkItem!WorkItemImage16x16" />   </ImageReferences>   <StringResources>   <StringResource ID="Description.d045e26294484a5193223c2b807054fa" />   <StringResource ID="DisplayName.30f06ee47fd8404b89af60e52a9d6fa9" />   <StringResource ID="CreatedDate.1700cad59e4348adb7361966969834a5" />   <StringResource ID="Description.79c7df27bfb84eb4951ab527fd9b0952" />   <StringResource ID="Id.3e6b4664852e4b629b7a1ef9afc68842" />   <StringResource ID="LastModified.dfe6975f30d74c52a28195f7aae9108a" />   <StringResource ID="Title.44ef1086055147278e8f08099d23f77b" />   <StringResource ID="CreatedDate.739810e72b5145558c9f07a1b96def84" />   <StringResource ID="Description.f075b2ab8d9f4a6eacdcb7eff2d1eef7" />   <StringResource ID="Id.3a604d3142fa4ce3bab913e5a036e18a" />   <StringResource ID="LastModified.985256ae2873442581403e96820ddf3b" />   <StringResource ID="Title.a3f6dcad2ecf4a609b68c16c58f81602" />   </StringResources>   </Presentation>   <LanguagePacks>   <LanguagePack ID="ENU" IsDefault="true">   <DisplayStrings>   <DisplayString ElementID="System.WorkItem.AssignedToUser.Projection">   <Name>Work Item Assigned To User</Name>   </DisplayString>   <DisplayString ElementID="WorkItemsAssignedToMeDEU">   <Name>Work Items Assigned to Me</Name>   <Description>Contains a special type projection and a single view for Work Items Assigned to Me</Description>   </DisplayString>   <DisplayString ElementID="View.WorkItemsAssignedToMeDEU">   <Name>Work Items Assigned To Me</Name>   </DisplayString>   <DisplayString ElementID="Description.d045e26294484a5193223c2b807054fa">   <Name>Description</Name>   <Description>Description</Description>   </DisplayString>   <DisplayString ElementID="DisplayName.30f06ee47fd8404b89af60e52a9d6fa9">   <Name>Display Name</Name>   <Description>Display name</Description>   </DisplayString>   <DisplayString ElementID="CreatedDate.1700cad59e4348adb7361966969834a5">   <Name>Created Date</Name>   <Description>Created date</Description>   </DisplayString>   <DisplayString ElementID="Description.79c7df27bfb84eb4951ab527fd9b0952">   <Name>Description</Name>   <Description>Description</Description>   </DisplayString>   <DisplayString ElementID="Id.3e6b4664852e4b629b7a1ef9afc68842">   <Name>ID</Name>   <Description>Work item ID</Description>   </DisplayString>   <DisplayString ElementID="LastModified.dfe6975f30d74c52a28195f7aae9108a">   <Name>Last Modified</Name>   <Description>Last modified</Description>   </DisplayString>   <DisplayString ElementID="Title.44ef1086055147278e8f08099d23f77b">   <Name>Title</Name>   <Description>Title</Description>   </DisplayString>   <DisplayString ElementID="CreatedDate.739810e72b5145558c9f07a1b96def84">   <Name>Created Date</Name>   <Description>Created date</Description>   </DisplayString>   <DisplayString ElementID="Description.f075b2ab8d9f4a6eacdcb7eff2d1eef7">   <Name>Description</Name>   <Description>Description</Description>   </DisplayString>   <DisplayString ElementID="Id.3a604d3142fa4ce3bab913e5a036e18a">   <Name>ID</Name>   <Description>Work item ID</Description>   </DisplayString>   <DisplayString ElementID="LastModified.985256ae2873442581403e96820ddf3b">   <Name>Last Modified</Name>   <Description>Last modified</Description>   </DisplayString>   <DisplayString ElementID="Title.a3f6dcad2ecf4a609b68c16c58f81602">   <Name>Title</Name>   <Description>Title</Description>   </DisplayString>   </DisplayStrings>   </LanguagePack>   <LanguagePack ID="DEU" IsDefault="false">   <DisplayStrings>   <DisplayString ElementID="System.WorkItem.AssignedToUser.Projection">   <Name>Dem Benutzer zugewiesene Arbeitsaufgaben</Name>   </DisplayString>   <DisplayString ElementID="WorkItemsAssignedToMeDEU">   <Name>Mir zugewiesene Arbeitsaufgaben</Name>   <Description>Contains a special type projection and a single view for Work Items Assigned to Me</Description>   </DisplayString>   <DisplayString ElementID="View.WorkItemsAssignedToMeDEU">   <Name>Mir zugewiesene Arbeitsaufgaben</Name>   </DisplayString>   <DisplayString ElementID="Description.d045e26294484a5193223c2b807054fa">   <Name>Beschreibung</Name>   <Description>Beschreibung</Description>   </DisplayString>   <DisplayString ElementID="DisplayName.30f06ee47fd8404b89af60e52a9d6fa9">   <Name>Anzeigename</Name>   <Description>Anzeigename</Description>   </DisplayString>   <DisplayString ElementID="CreatedDate.1700cad59e4348adb7361966969834a5">   <Name>Erstellt am</Name>   <Description>Erstellt am</Description>   </DisplayString>   <DisplayString ElementID="Description.79c7df27bfb84eb4951ab527fd9b0952">   <Name>Beschreibung</Name>   <Description>Beschreibung</Description>   </DisplayString>   <DisplayString ElementID="Id.3e6b4664852e4b629b7a1ef9afc68842">   <Name>ID</Name>   <Description>Arbeitsaufgabe ID</Description>   </DisplayString>   <DisplayString ElementID="LastModified.dfe6975f30d74c52a28195f7aae9108a">   <Name>Zuletzt geändert</Name>   <Description>Zuletzt geändert</Description>   </DisplayString>   <DisplayString ElementID="Title.44ef1086055147278e8f08099d23f77b">   <Name>Titel</Name>   <Description>Titel</Description>   </DisplayString>   <DisplayString ElementID="CreatedDate.739810e72b5145558c9f07a1b96def84">   <Name>Erstellt am</Name>   <Description>Erstellt am</Description>   </DisplayString>   <DisplayString ElementID="Description.f075b2ab8d9f4a6eacdcb7eff2d1eef7">   <Name>Beschreibung</Name>   <Description>Beschreibung</Description>   </DisplayString>   <DisplayString ElementID="Id.3a604d3142fa4ce3bab913e5a036e18a">   <Name>ID</Name>   <Description>Arbeitsaufgabe ID</Description>   </DisplayString>   <DisplayString ElementID="LastModified.985256ae2873442581403e96820ddf3b">   <Name>Zuletzt geändert</Name>   <Description>Zuletzt geändert</Description>   </DisplayString>   <DisplayString ElementID="Title.a3f6dcad2ecf4a609b68c16c58f81602">   <Name>Titel</Name>   <Description>Titel</Description>   </DisplayString>   </DisplayStrings>   </LanguagePack>   </LanguagePacks>  </ManagementPack>

Problem talk creates problems, solution talk creates solutions (Steve deShazer)

Reply:

You modified the xml code directly?

If yes, maybe you are interessted in an Editor?

System Center Service Manager 2010 - Language Pack Editor

Andreas Baumgarten | H&D International Group

------------------------------------

Dynamic hierarchy in a MDX query

I would like to use a dynamic hierarchy in my query, because I need to use [Dimension].[Hierarchy 1] to [Dimension].[Hierarchy 6]

If I define a calculated member "[HierarchyTest]" in my query it's working fine.

If I create a parameter with the same value as my calculated member [HierarchyTest] and I replace in query (STRTOMEMBER(HierarchyTest) with STRTOMEMBER(@parameter)), I obtain "[All]".

What I'm doing wrong, please?

Thank you!

WITH

MEMBER [HierarchyTest] AS "[Dimension].[Hierarchy 1].CURRENTMEMBER"

MEMBER [Measures].[ParameterCaption] AS STRTOMEMBER(HierarchyTest).MEMBER_CAPTION

MEMBER [Measures].[ParameterValue] AS STRTOMEMBER(HierarchyTest). UNIQUENAME

MEMBER [Measures].[ParameterLevel] AS STRTOMEMBER(HierarchyTest).LEVEL.ORDINAL

SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,

[Dimension].[Hierarchy 1].ALLMEMBERS ONROWS

FROM [Cube]

Geozah

Edited by Mano__ Wednesday, February 29, 2012 2:08 PM

Reply:

That is because the parameter passed is evaluated once and CurrentMember has the value [All] at the highest level

You can use the following construct to determine the hierarchy being used on the ROWS axis, aka Axis(1), and create the calc'd members

Something like

WITH

MEMBER [Measures].[ParameterCaption] AS Axis(1).Item(0).Item(0).Hierarchy.CurrentMember.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue] AS Axis(1).Item(0).Item(0).Hierarchy.CurrentMember.UNIQUENAME
MEMBER [Measures].[ParameterLevel] AS Axis(1).Item(0).Item(0).Hierarchy.CurrentMember.LEVEL.ORDINAL
SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,
[Dimension].[Hierarchy 1].ALLMEMBERS ONROWS
FROM [Cube]

hth

-Remember to mark as helpful/the answer if you agree with the post.

------------------------------------
Reply:

Hello Naveen Das,

Thank you for your answer, but I'm not sure I understand where I can use my parameter in the query you suggested.

I found another way but it's working only a half :), do you have any idea?

I have an error message when I try to use my calculated member on rows:

The ALLMEMBERS fonction expects a level expression for first argument. A member expression was used

WITH

MEMBER [Hierarchy] AS

(

CASE

when@GroupO = "1" then("[Dimension].[Hierarchy 1].CURRENTMEMBER")

when@GroupO = "2" then("[Dimension].[Hierarchy 2].CURRENTMEMBER")

when@GroupO = "3" then("[Dimension].[Hierarchy 3].CURRENTMEMBER")

End

)

MEMBER [Measures].[ParameterCaption] AS strtomember([Hierarchy]).MEMBER_CAPTION

MEMBER [Measures].[ParameterValue] AS STRTOMEMBER([Hierarchy]).UNIQUENAME

MEMBER [Measures].[ParameterLevel] AS STRTOMEMBER([Hierarchy]).LEVEL.ORDINAL

SELECT {

[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]

} ONCOLUMNS,

STRTOMEMBER([Hierarchy]).ALLMEMBERS on rows

//[Dimension].[Hierarchy 1].ALLMEMBERS ON ROWS

FROM [Cube]

Thank you for your suggestions!

Geozah

------------------------------------
Reply:

Lets break it down into 2 posts. In this one I will tell you how you can use my version and pass the parameter. The value of @parameter should be of the form [Dimension].[Hierarchy]

WITH MEMBER [Measures].[ParameterCaption] AS Axis(1).Item(0).Item(0).Hierarchy.CurrentMember.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue] AS Axis(1).Item(0).Item(0).Hierarchy.CurrentMember.UNIQUENAME
MEMBER [Measures].[ParameterLevel] AS Axis(1).Item(0).Item(0).Hierarchy.CurrentMember.LEVEL.ORDINAL
SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,
STRTOSET(@parameter + "ALLMEMBERS") ON ROWS
FROM [Cube]

-Remember to mark as helpful/the answer if you agree with the post.

------------------------------------
Reply:

In your version, you have to build the string and use STRTOSET function on the axis. Again, @parameter has to be of the form [Dimension Name].[Hierarchy Name]

WITH
MEMBER [Hierarchy] AS
(
CASE
when @GroupO = "1" then("[Dimension].[Hierarchy 1].CURRENTMEMBER")
when @GroupO = "2" then("[Dimension].[Hierarchy 2].CURRENTMEMBER")
when @GroupO = "3" then("[Dimension].[Hierarchy 3].CURRENTMEMBER")
End
)
MEMBER [Measures].[ParameterCaption] AS strtomember([Hierarchy]).MEMBER_CAPTION
MEMBER [Measures].[ParameterValue] AS STRTOMEMBER([Hierarchy]).UNIQUENAME
MEMBER [Measures].[ParameterLevel] AS STRTOMEMBER([Hierarchy]).LEVEL.ORDINAL
SELECT {
[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]
} ONCOLUMNS,

STRTOSET(@parameter + ".ALLMEMBERS") on rows
//[Dimension].[Hierarchy 1].ALLMEMBERS ON ROWS
FROM [Cube]

-Remember to mark as helpful/the answer if you agree with the post.

------------------------------------
Reply:

Hello again,

I kept my version and used your suggestion for STRTOSET function on the axis and it's working fine.

Thank you and have a nice day!

Geozah

------------------------------------

Need list of shortcut keys for Win 8 "Consumer Preview" running as a Hyper-V Guest

I installed Win 8 Consumer Preview in a Hyper-V Guest on my local workstation (HOST) and am accessing it directly from the Host. Does anyone have a list of "shortcut" keys that apply to a Win 8 Consumer Preview Guest? (For example, the normal Windows key causes the Start menu of the HOST, not the Guest, to appear. Sure, that makes sense but it doesn't help me maneuver around in the Guest.)

TIA,

Barkingdog

Reply:

Windows does not include shortcut keys specifically for use as a Guest. This would be a function of the virtualization software. For example, Hyper-V has a setting to control the focus of Windows key combinations named Use on the virtual machine. This should redirect keyboard combinations to the guest.

Mike Stephens [MSFT] | Support Escalation Engineer | Windows Distributed Systems | Charlotte, NC USA

------------------------------------

Do we need to install Project server TFS integration feature pack in TFS App Tier?

Hi ,

We have set up project server 2010 in one server and TFS2010 in another server . We are doing TFS - Project server integration.

I have came across the http://msdn.microsoft.com/en-us/library/gg412642.aspx (TFS-Project server Integration Quick Reference).

I would like to confirm my understanding that integration feature pack need to be installed in project server alone, no need to install it in TFS server.

Please confirm.

Thanks, Lovely

Reply:

You got it right, you have to install the FeaturePack only on Project Server, there is no need to install this pack to TFS servers.

Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

------------------------------------
Reply:

Thanks for the confirmation.

Thanks, Lovely

------------------------------------

HOSTS file in DNS server - why not?

Can DNS server resolve names through HOSTS file or WINS server through LMHOSTS file?
Why not?

How DNS query works (technet.microsoft .com article) tells that DNS server does not use its HOSTS file

Does it imply that domain contoller cannot ever use HOSTS file?

Reply:

I'd like to rectify my interest.

If it could have been a convenient possibility to create aliases without necessity of creating authoritative dns zones (?) , at least, for local subnet users (?).
Or I miss the point of hierarchical DNS name resolution?

This question is related to my question in post
intranet vs. internet website name resolution
in part of creating an alias without creating (authoritative) zone,
namely to the phrase:

"If you want to create an alias called www.test.com, that record must be defined in the DNS zone called test.com. There is no way around that. That is how DNS works. If you want to create an alias called www.mydomain.com and point it to www.test.com, you can do that as well by creating an alias record (CNAME) in the mydomain.com zone pointing to the www.test.com record"

------------------------------------
Reply:

> Can DNS server resolve names through HOSTS file or WINS server through LMHOSTS file?
Why not?

If you are physically using the DNS server console opening a web browser and typing in a URL name that is int he hosts file, then the local client side resolver service will use the hosts file. If any user is querying the DNS server to resolve names, no, the DNS server Service uses either the DNS database it hosts, forwarders, stubs, or any other number of means to resolve the name for the querying client, but it will not use the hosts file. Same thing goes with WINS.

Why not? Because it uses its own database. The DNS and WINS service do not look at the hosts or lmhosts files. It's the way DNS and WINS works.

> Does it imply that domain contoller cannot ever use HOSTS file?

My example wtih the URL above applies to this question, too.

> If it could have been a convenient possibility to create aliases without necessity of creating authoritative dns zones (?) , at least, for local subnet users (?).
Or I miss the point of hierarchical DNS name resolution?

A querying client from one machine cannot query or use the hosts file of another machine. However you can fill out a hosts file with the necessary records you want everyone to use, then copy it to other machines overwriting their default hosts files. That's the best you can get in a workgroup as you describe.

> This question is related to my question in post
intranet vs. internet website name resolution
in part of creating an alias without creating (authoritative) zone,
namely to the phrase:

"If you want to create an alias called www.test.com, that record must be defined in the DNS zone called test.com. There is no way around that. That is how DNS works. If you want to create an alias called www.mydomain.com and point it to www.test.com, you can do that as well by creating an alias record (CNAME) in the mydomain.com zone pointing to the www.test.com record"

An alias is a name that points to another name. An alias is created under your own domain's authorative zone, but the name it points to is not authorative on your end, rather who owns the zone.

Ace Fekay, MVP, MCT, MCITP EA, MCTS Windows 2008 & Exchange 2007, MCSE & MCSA 2003/2000, MCSA Messaging 2003, Microsoft Certified Trainer, Microsoft MVP - Directory Services. This posting is provided AS-IS with no warranties or guarantees and confers no rights.

------------------------------------
Reply:

Just to rectify terminology of this topic:
inability of DNS server to use HOSTS file does not mean that machine which hosts DNS server cannot use its HOSTS file.
True?

Can a machine hosting DNS server indicate its own DNS server in machine NIC props as 127.0.0.1?

------------------------------------
Reply:

> Just to rectify terminology of this topic:
inability of DNS server to use HOSTS file does not mean that machine which hosts DNS server cannot use its HOSTS file.
True?

Yes, that's true.

> Can a machine hosting DNS server indicate its own DNS server in machine NIC props as 127.0.0.1?

Yes, it can.

------------------------------------
Reply:

Thanks, once more.
Answered

------------------------------------
Reply:

Thanks, once more.
Answered

You are welcome.

------------------------------------
Reply:

Okay, so the Microsoft DNS server does not use its own hosts file when resolving DNS queries.

Is there to make it use a hosts file though? Or is there a way to import all the entries from a hosts file to its DNS database?

For example, this hosts file?

Thanks

Edited by jason404 Thursday, February 23, 2012 4:43 AM

------------------------------------
Reply:

Okay, so the Microsoft DNS server does not use its own hosts file when resolving DNS queries.

Is there to make it use a hosts file though? Or is there a way to import all the entries from a hosts file to its DNS database?

For example, this hosts file?

Thanks

Not directly. You can import that into Excel as a CSV, then use DNSCMD to import it, as Tiger suggested below in another thread. Basically it creates a zone file for each entry in the host file.

http://social.technet.microsoft.com/Forums/en-US/winserverNIS/thread/425990d6-27ee-426c-a9ad-416b6c046f1e/
The following was quoted from Tiger in the above link:

==============
From my knowledge, I believe that there hasn't a tool out there that we may use to import record from txt or CSV files. However, you can achieve your goal with the batch file with DNScmd utility indirectly.

1.Input the host file's record to excel , format the record to host and domain with the "text to columns" feature .
2.Input the domain zone (If you need to create a new zone for those DNS records) and hosts record to DNS server

dnscmd [<ServerName>] /zoneadd <ZoneName> <ZoneType>
dnscmd [<ServerName>] /recordadd <ZoneName> <NodeName> <RRType> <RRData>

For batch operation, I suggest you to write all command in one batch file and execute it.

DNScmd utility for you reference

Dnscmd Overview
http://technet.microsoft.com/en-us/library/cc778513(WS.10).aspx

Dnscmd Syntax
http://technet.microsoft.com/en-us/library/cc756116(WS.10).aspx#BKMK_14
=============

More references and links to give you some pointers, methods and other help with people who've asked before.

Import into DNS Hosts from CSV file
http://www.techtalkz.com/windows-server-2003/424720-import-into-dns-hosts-csv-file.html

DNS Import of /etc/hosts file
https://lists.isc.org/pipermail/bind-users/1999-November/006434.html

Import hosts file into DNS
http://arstechnica.com/civis/viewtopic.php?f=17&t=473238

Ace Fekay
MVP, MCT, MCITP Enterprise Administrator, MCTS Windows 2008 & Exchange 2007 & Exchange 2010, Exchange 2010 Enterprise Administrator, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

This posting is provided AS-IS with no warranties or guarantees and confers no rights.

------------------------------------
Reply:

Thanks a lot for your answer. I am surprised that it is not possible to use the hosts file, or some other single file though, as it is possible to in dnsmasq for Linux, and probably BIND as well, I would have thought.

------------------------------------
Reply:

Same as Microsoft DNS, it's not directly possible in BIND. Remember, Microsoft DNS works similarly to BIND, since they both follow the industry standard DNS RFCs defining how DNS works.

As the link I provided above indicates, you still have to change the HOSTS file into a CSV file, then import the file into DNS.

DNS Import of /etc/hosts file
https://lists.isc.org/pipermail/bind-users/1999-November/006434.html

This posting is provided AS-IS with no warranties or guarantees and confers no rights.

------------------------------------

issue with deployment

i have a visual webpart i try to deploy it to a site in sharepoint but i got the error

Warning 1 D:\Project\Ninj\Test\VisualWebPartProject1\VisualWebPartProject1\VisualWebPart1\VisualWebPart1UserControl.ascx: ASP.NET runtime error: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D5140C1-7436-11CE-8034-00AA006009FA}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). D:\project\Ninj\Test\VisualWebPartProject1\VisualWebPartProject1\VisualWebPart1\VisualWebPart1UserControl.ascx 1 1 VisualWebPartProject1

also got another error as could not load the web.config configuration file check the file for any malfunction XML elements and try again

the following error occured Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider' This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D5140C1-7436-11CE-8034-00AA006009FA}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

Alen Austin

Changed type Alen Austin Friday, February 24, 2012 9:54 AM no replies

Reply:

Hi,

What exactly you are doing within the visual web part? The error sounds like some error with the COM objects. I hope you are invoking some non .Net dll interfaces within it.

Kathir

------------------------------------
Reply:

Hi Alen,

Please check this url .http://forum.techisolutions.info/t2-unable-to-cast-com-object-error-in-sharepoint#3.

They are basically asking you to check the dll registrations on your machine.

Thanks,

Salu

------------------------------------

Signed LDAP - problem with web app

i have application using LDAP queries (ad 2008) to authenticate users and allow/disallow access to some website modules. Everything works ok untill SA implement signed LDAP queries GPO - queries not signed are rejected. App use windows auth only. I have few questions regarding signed LDAP:

- should my web app use special account to connect to LDAP and next query LDAP about user connected to app? can you provide me some example ?

- it is possible to use impersonation (user under app pool works) to query LDAP - how to impement it ?

- there are IIS modules required to support signed LDAP queries - for exp. digest auth?

i will appreciate any help

thx

Reply:

Take a look at below article.

http://blogs.technet.com/b/askds/archive/2009/09/21/understanding-ldap-security-processing.aspx

Awinish Vishwakarma - MVP-DS

My Blog: awinish.wordpress.com

Disclaimer This posting is provided AS-IS with no warranties/guarantees and confers no rights.

------------------------------------

Hardware & Configuration Advice for Hyper-V

What do you recommend for CPU & RAM for each machine?

Users:20
Mailboxes:20 (100 messages/day)
Database:40GB

Machine 1: Host OS = Hyper-V role only
VM1 - Server 2008 R2 - Active Directory, DS, DNS, etc
VM2 - Server 2008 R2 - Exchange Server 2010 Std

Machine 2: Host OS = Hyper-V role only
VM3 - Server 2008 R2 - SQL 2008 R2 Std / Microsoft Dynamics NAV

I would like the machine sized so that I could run all VMs on a single machine if one went down.

Changed type Vincent Hu Tuesday, March 6, 2012 1:34 PM

Reply:

It depends on your usage scenario.

- Cached Exxhange mode?
- Why Dynamics NAV on the same as SQL server?
- How many NAV users?
- Is there a secondary DC?
- What is mailboks storage limitation per user? (if any implemented)

Bascially your sizing is limited to the total amount your host has available... Everything under that, you can set as you like.

So whats the Specs of your HyperV host?

------------------------------------

SBS2008 VPN Windows XP auth fail

Hieveryone!

Faced with the following issues:

I have aSBS2008 server and I set the VPN access.
However, that only two newly created user, I agreed not to everyone else.As both the user's credentials have been received, users can connect to it via VPN.These two users are allowed access only to certain folders on the server (ACL). Windows 7 works well for clients when connected via VPN, only the folders is achieved,which enabled the2 VPN user.
However, WindowsXP, the VPN connection after the VPN users (which joined) assigned to folders reach the server, but users with the original (which he can enter into Windows) permissions assigned to that (althought here is no right to connect via VPN).
Has anyone encountered this problem and if so, how to solve?

Thank you in advance!

Edited by Csabaa80 Friday, February 17, 2012 3:24 PM
Changed type Sean Zhu - Thursday, February 23, 2012 6:44 AM no response

Reply:

Can you restate the problem, your question is not very clear.

Robert Pearman SBS MVP (2011) | www.titlerequired.com | www.itauthority.co.uk

------------------------------------
Reply:

Ok. Sorry for my english.... :(

SBS2008 server, VPN. There is a dedicated domain user - for example X. He has the right to access via vpn to the server. There is a domain user - for example Y, he has no vpn access. Y use X credentials to VPN.

If Y use Win7 client, its work correctly. Y only see the folders of X. If Y use WinXP client, he access the own folders, and don't see the X folders.

Thank You!

Edited by Csabaa80 Tuesday, February 28, 2012 4:52 PM

------------------------------------
Reply:

If user Y has to use user X credentials to VPN - why not allow User Y to vpn in as well?

Robert Pearman SBS MVP (2011) | www.titlerequired.com | www.itauthority.co.uk

------------------------------------

FYI: Note for Forefront Protection for Exchange users and Exchange 2010 SP2 rollup1

I've found this information in the Forefront Server Protection blog:

http://blogs.technet.com/b/fss/archive/2012/02/29/update-rollup-1-for-exchange-2010-service-pack-2.aspx

"Note for Forefront Protection for Exchange users

For those of you runningForefront Protection for Exchange, be sure you perform these important steps from the command line in the Forefront directory before and after this rollup's
installation process. Without these steps, Exchange services for Information Store and Transport will not start after you apply this update. Before installing the update, disable ForeFront by using this command: fscutility /disable. After installing the update, re-enable ForeFront by running fscutility /enable."

<o:p></o:p>

Christian Groebner MVP Forefront

Changed type Nick Gu - MSFT Friday, March 16, 2012 6:39 AM

Ms Support forum

Tuesday, March 1, 2022