Tuesday, February 1, 2022

How do I sort a Delimited text file by the second delimitation?

I have a text file that is laid out as such:

aaaa aaa (2000)
bbb bbb bb (2001)
cccc,ccc (1999)
ddd dddddd (2004)

I would like to be able to make a VBScript that sorts the text file and makes a new csv from it that has it in order by (*). That way it would list back:

cccc,ccc (1999)
aaaa aaa (2000)
bbb bbb bb (2001)
ddd dddddd (2004)

I tried a couple times using some other scripts but I am pretty new at this and figured I should reach out for help.

Thank you for any help you could give.

Edited by philip.terry Tuesday, May 26, 2015 6:23 PM
Changed type Bill_Stewart Thursday, July 9, 2015 4:51 PM
Moved by Bill_Stewart Thursday, July 9, 2015 4:51 PM This is not "scripts on demand"

Reply:

The script request form is here:

https://gallery.technet.microsoft.com/scriptcenter/site/requests

This forum is for specific questions rather than script requests.

-- Bill Stewart [Bill_Stewart]

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

Your file is too odd to be easily converted. You need to use a real file and not one you have made up.

Start by learning how too use VBScript (I recommend skipping vbscript for PowerShell.

Start here: https://technet.microsoft.com/en-us/scriptcenter/dd793612.aspx?f=255&MSPPError=-2147217396

\_(ツ)_/

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

Here is an example of why it won't work:

PS C:\scripts> $file  col1,col2,col3  aaaa,aaa,(2000)  bbb,bbb,bb,(2001)  cccc,ccc,(1999)  ddd,dddddd,(2004)  PS C:\scripts> $file|ConvertFrom-Csv    col1 col2 col3  ---- ---- ----  aaaa aaa (2000)  bbb bbb bb  cccc ccc (1999)  ddd dddddd (2004)      PS C:\scripts> $file|ConvertFrom-Csv|sort col3    col1 col2 col3  ---- ---- ----  cccc ccc (1999)  aaaa aaa (2000)  ddd dddddd (2004)  bbb bbb bb

\_(ツ)_/

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

I started by making a new delimitation so instead of being in the format of

title (year)
It is now
title~year

I was told this may help in the organizing process as I could move everything after the "~" to the front of the line then just use a basic sort command but I do not know how to move everything after the "~" to the front...

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

Again: This forum is for specific questions rather than script requests.

As noted, this will be simpler to accomplish in PowerShell than VBScript, but this isn't the right place to ask others to write a script for you. You can request a script here:

https://gallery.technet.microsoft.com/scriptcenter/site/requests

As with this forum, there is no service-level agreement that guarantees someone will take the time to do this for you. If it is critical to business, I recommend hiring a consultant.

-- Bill Stewart [Bill_Stewart]

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

A comma separted file is a specific structure. You cannot just change delimiters and get one.

All row must have the some number of columns. Delimiters are usually either comma or semicolon but can be pipe or other character. IF you cannot prove this then you will likely need to hire a consultant to help you with this.

http://en.wikipedia.org/wiki/Comma-separated_values

\_(ツ)_/

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

I doubt anyone else will ever need this script so I think putting it in the repository would be a waste of time. Therefore I'll just post it here:

'---------------------------------------------------------------------  ' This script requires .NET Framework 1.1 or later  '---------------------------------------------------------------------  strInputFile = "C:\Path\To\File\input.txt"  strOutputFile = "C:\Path\To\File\output.txt"  '---------------------------------------------------------------------  ' No need to edit below this line  '---------------------------------------------------------------------  Const ForReading = 1  Const Overwrite = True    Set objFSO = CreateObject("Scripting.FileSystemObject")  Set objInputFile = objFSO.OpenTextFile(strInputFile, ForReading)  Set objOutputFile = objFSO.CreateTextFile(strOutputFile, Overwrite)  Set objSortedList = CreateObject("System.Collections.Sortedlist")  Set objRegEx = CreateObject("VBScript.RegExp")  Set objShell = CreateObject("WScript.Shell")    objRegEx.Global = True   objRegEx.IgnoreCase = True  objRegEx.Pattern = "(.*)\((\d{4})\)"    Do While objInputFile.AtEndOfStream = False   strLine = objInputFile.ReadLine   Set colMatches = objRegEx.Execute(strLine)  	If colMatches.Count > 0 Then  		For Each strMatch in colMatches  			strTitle = strMatch.SubMatches(0)  			strYear = strMatch.SubMatches(1)  			strEntry = strYear & ";" & strTitle  			objSortedList.Add strEntry, strEntry  		Next  	End If  Loop    For i = 0 To objSortedList.Count - 1  	arrEntries = Split(objSortedList.GetKey(i), ";")  	objOutputFile.WriteLine arrEntries(1) & "(" & arrEntries(0) & ")"  Next    objShell.Run("notepad.exe " & strOutputFile)

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

Display both married and others in one form

Hello -]

is there a way to display the address contents of Married and others in a form.

I have a column of FamStatus as (1 for single, 2 for married and 3 for all others)

Was able to get the married portion display because I figured that Primary Contact name was different from Spouse FirstName and LastName.

So with Single person, the Primary Contact is the single and you can't compare it to any other information. is there a way I can use Famstatus to resolve my issues?

Any help would be greatly appreciated..

VLAN - Please explain this to me

I have a Win 8.1 Pro workstation. This is my management system so I need to access 2 different VLANs. VLAN1 (untagged) is our data lan and has internet connectivity. VLAN10 is tagged and is our VOIP VLAN. It has no internet connectivity. I need to be able to access both VLANs. VLANs are on separate subnets.

My workstation has a Intel I350-T2V2 NIC which both ports are teamed and is untagged (VLAN1). I'm using a port on the motherboard (I210) for VLAN10 (tagged).

In Network Connections -> Advanced -> Advanced Settings -> I have the NIC Team (VLAN1) set 1st and VLAN10 second.

In Network Connections VLAN10 shows No Internet access; which is what I expect as it doesn't.

When browsing or doing tracerts to internet sites sometimes it goes to the VLAN1 gateway and sometimes it goes to the VLAN10 gateway. I expected it to always use VLAN1 as I have it set 1st.

How do I force it to always use VLAN1 for everything except the VLAN10 subnet?

AppV5 on RDS session hosts - all kinds of issues, am I alone?

Hi,

after months of struggling I am about to have had it with AppV5. A little information:

- A farm of 2008R2 RDS session host servers
- This is a shared farm, shared between several smaller clients / companies
- AppV5 sp3 client installed
- AppV5 full infrastructure, streaming from SMB share
- Only user per user publishing, no system-wide publishing
- Connection groups for several applications, with correct priorities

I keep running into issues with this setup;

When assigning apps to a user, per server the first time an aplication or connection group is started, it's extremely slow especially when Office (2010) is involved. This is discussed in https://social.technet.microsoft.com/Forums/en-US/mdopappv/thread/44944302-d8f3-4df1-b104-9c63345f88e0/#3324f16f-beb1-4fce-8475-6224a01664a6. While I can overcome that with some customizations that's already one thing I am unhappy with.

Then as the AppV5 client service stores user-related data in HKLM\Software\Microsoft\AppV, whenever a user logs of that data is kept on the server. Whenever an application or connection group is updated we run into issues. When he logs on again and happens to land on a server he was on before, the refresh most of the times fails with errors like

That's just an example, error messages vary.

Now I've found that when I remove all the specific user-values from HKLM\Sofware\Microsoft\AppV and have the user logon to that server again or manually do the sync again, everything works flawlessly. For some reason the Sync-AppVPublishingServer is not able to update properly when I don't cleanup that data.

Sync speed. I've asked this before but didn't get a real answer. With AppV4, when a user logs in the shortcuts are there immediately and can be started immediately. When a user has new appilation published, they appear within seconds, and they stay there, in a 'startable state' after user logs in again. Now with AppV5, when a user logs in to a server, all AppV5 shortcuts are 'white' and not startable. Only when the AppV sync has been done the shortcuts get their proper icon and are startable. This sometimes takes up to 10 seconds. Login speed and performance is a key performance indicator in our vision and also from user perspective a very important indicator. Going back from immediately being able to start applications to having to wait for about 10 seconds to do so is appaling according to our users (and I can't blaim them either).

Whenever a connectiongroup has been updated, most of the time when a user logs in he gets the 'Application update - please stop your application and try again' (don't have the exact message by hand now but you'll all recognize it). I think this happens when a user starts the application 'too soon' after logging in. The syc process runs, but I feel the UI bar in the bottom right of the screen is gone after the applications have been synced, but the connection groups still have to update. Anyway, the user then stops their applications and tries again, which sometimes works. However, as user-settings are saved in HKLM, whenever he lands on another RDS the same issue happens again. Again it seems the sync-appvpublishing server is either too slow or not functional enough.

In my testenvironment I have now created a tool that removes a users HKLM AppV references after he has logged off. In my tests that already saved quite some problems but not all.

I feel AppV5 is more 'dedicated' to VDI environments where the profie or AppV part of the registry builds from scratch at every login, not to run on multiuser systems. In addition I think the performance of AppV5 in terms of for example it's synchronizing and filling the registry for an application or connection group is two steps behind AppV4. Especially the way shortcuts are not usable when a user gets his desktop shown after login is beyond believe, how is that an improvement?

I think my question is if there are some people here that run AppV5 on multiple RDS session hosts with applications (and connection groups) published on userbase, and to share their ideas, frustrations , issues and ofcourse solutions.

Changed type Brandon RecordsModerator Saturday, June 13, 2015 1:45 PM Conversation focuses on best practices and opinions of App-V

Reply:

Yes, I have seen the "network" error before in a similar environment. This was solved by letting the Sync process complete before the user can start applications.

If there are already shortcuts on the system, maybe PreserveUserIntegrationsOnLogin can solve some issues. This skips the "cleanup".

Twitter | Blog | App-V Deployment Whitepaper
If you see a post that helped you please click "Vote As Helpful" and if it answered your question please click "Mark As Answer". This forum post is based upon my personal experience and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

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

Thanks for your response. I have tested with PreserveUserIntegrationsOnLogin, it doesn't make a great diference in my environement. The most important part though is that the issues when application membership or connectiongroups have changed still exist per user per server. That specific issue makes it extremely hard to 'sell' this to our users and to myself.

Tell users not to start an application when the shortcuts are already there. I don't know how to PREVENT them from doing it, but I can tell you just asking them is not sufficient :) Still I think that's a bad point to start from in the first place; the sync / refresh process is way too slow in my oppinion, especially when compared to previous AppV versions.

How did you cope with that in your environment?

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

Thanks for your response. I have tested with PreserveUserIntegrationsOnLogin, it doesn't make a great diference in my environement. The most important part though is that the issues when application membership or connectiongroups have changed still exist per user per server. That specific issue makes it extremely hard to 'sell' this to our users and to myself.

Tell users not to start an application when the shortcuts are already there. I don't know how to PREVENT them from doing it, but I can tell you just asking them is not sufficient :) Still I think that's a bad point to start from in the first place; the sync / refresh process is way too slow in my oppinion, especially when compared to previous AppV versions.

How did you cope with that in your environment?

They used RES Workspace Manager so the RES splash screen was displayed until the Sync was finished.

Can't you add the package globally (with CSC enabled) on the RDS servers and publish them per user?

An alternative could be to use App-V Scheduler

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

Thanks for your reply. Sorry, I think I'm overexhausted by now, what do you mean with CSC?

By the way I know I could prepublish packages, but that doesn't prepublish the registry. It might help on the sync issues (which is the most important annoyance of AppV5 imho) but doesn't save the user from an extremely slow session for minutes. As we have users with either Office 2010, 2013 or Libreoffice, I can't publish office globally. Filling the registry of Office (especially 2010) takes minutes on 40-core HP Gen9 servers (I know it's just a single thread process, but I want to make clear we don't have 'pussy' hardware :)). As far as I know I must manually start the connectiongroup or application in order for the registry to start building up, OR put it in myself (like export / import reg file basically, but then more sophisticated).

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

Thanks for your reply. Sorry, I think I'm overexhausted by now, what do you mean with CSC?

By the way I know I could prepublish packages, but that doesn't prepublish the registry. It might help on the sync issues (which is the most important annoyance of AppV5 imho) but doesn't save the user from an extremely slow session for minutes. As we have users with either Office 2010, 2013 or Libreoffice, I can't publish office globally. Filling the registry of Office (especially 2010) takes minutes on 40-core HP Gen9 servers (I know it's just a single thread process, but I want to make clear we don't have 'pussy' hardware :)). As far as I know I must manually start the connectiongroup or application in order for the registry to start building up, OR put it in myself (like export / import reg file basically, but then more sophisticated).

Sorry, I ment SCS (Shared Content Store).

Keep in mind that scenarios involving multiple App-V 5.0 Office packages deployed on a client are not supported and Office 2013 needs to be published globally.

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

Are you using roaming profiles?

The network error you posted was something that took me a while to figure out. It can happens when you launch the eye before the app is published to the user. I have also seen it as a bug pretty SP3. It happens when the app services fills up the access list on the folder. SP3 fixed this bug that was introduced in SP2.

For reference, I have about 2500 users, 60 RDS (Citrix) servers, and around 75 Appv 5 apps. I have had comments from my users that's state they like Appv 5 better than 4 because it's faster And apps seem to work better.

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

Hi Joe,

thanks for your addition. I agree in AppV5 being (much) better with connection groups, with starting apps, and general maintenance as well. However the fact a user can actually start an application before the sync is done and it screws up the system, is bad design in my opinion. It's not like roaming profiles are new.

While you have 60 RDS servers, you must (?) have seen more issues like I have. For example when you add a new version of an app or a completely new app to a connection group, do users get like random error messages sometimes? As told I have issues which seem to occur because there is data stored for each user in HKLM which ofcourse doesn't roam. So when a has worked with a new app, and then logs on to another server he might as well get some error message again.

Still one of my main issues is that with AppV4 whenever the shortcut was there, the user could start it. It's hard to tell a customer to just wait, even if all shortcuts already exist. That's not an improvement over AppV4.

In an environment with 2500 users I assume you are using some form of profile management software? Do you include / exclude specific parts for AppV5

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

You stated that you cant publish Office globally, so does that mean that you have Office 2013 published to users? This could be what is causing alot of your slowness. Although 2013 does work "somewhat" when published to users, its not a supported configuration and really slows down the publishing time.

As far as the errors go when launching applications, this is most likely because of "stuff" being left behind from the users sessions that really need to be removed when they log off. What seems to be happening is that your extension points are becoming invalid because they log off their session on server A with entitlement set A, then lets say a week goes by where they log into other servers, meanwhile their set of entitlements changes, and then they hit server A again. Since their older session still contains those older entitlements (in registry and file system), you end up with the bunk icons.

What are you using for profile management?

Do you have any scripts that run when these servers are restarted to clean up App-V?

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

You are now semi-quoting me as I also noted that when I clean up that mess that's left behind, everything is ok again - on that specific server. The thing is I can't believe WHY AppV can't clean it up itself when it generates so much issues. I have created a cleanup-tool myself that runs when a user logs off, but it bugs sometimes so I have to take another look at that and implement some logging as well. However, as stated I am stunned to see we need profile management tools and cleanup scripts in order to work with a product like this. It's not like this is some old version of it either.

I do not publish Office globally. I know it's not supported with Office 2013, hence Office 2013 is not published in any way as of yet. I am thinking about 2 farms - one with Office 2010 and one with 2013, either through AppV or locally installed (doesn't really matter anymore then). However, the base issue of error messages whenever entitlements / connectiongroups change remains, which makes it VERY unfriendly towards users.

We are just a small company. We cannot afford, nor do I believe we (should) need a profile management software. Hence I currently only have options AD / roaming profiles and any custom scripts or tools I write allow me to do. Currently I don't have any specific profile scripts running. Just regular roaming profiles. The most basic setup and I still run into all these issues.

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

Yea, the reason I was semi-quoting you was to let you know that you weren't alone with these types of issues. It took me quite a while to get my RDS configuration solid.

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

Ah ok :) Well can you share WHAT exactly you excluded, included, cleaned from profile / HKLM or whatever else to get it more stable? By the way do you feel this is 'ok' or should this work better out-of-the-box in your view? The documentation does not cover anything like this...

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

Check out my wiki on this topic: http://social.technet.microsoft.com/wiki/contents/articles/25318.app-v-a-configuration-template-for-deploying-to-stateless-rds-clients-on-citrix-published-desktops-with-citrix-upm-for-profile-management.aspx

We are using essentially the exact same script on startup on our non-provisioned servers as well.

As far as if I feel 'ok' about it out of the box, that's a complicated question. I feel that it's 'ok' out of the box from the perspective of running in a vanilla environment without any types of layering, virtualization, or RDS. Where it becomes a bit more complicated is when any of these elements are added, but that goes with any types of tech. It really comes down to making sure that the user state is happy with the application state on the RDS server.

I started with 5.0 RTM, which was much, much more problematic in these areas, and they've done much to accomodate more complex environments with each hotfix and SP release.

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

Thanks a lot for your input. Having worked through your script it's funny to see I have every single step of that script in my own tool / script. While I now have a .net tool written for it for convenience, I also have it in a little .bat file in about 10 lines. That doesn't do the extensive logging but apart from that it's functionally the same. I'm personally still keen on bat and vbs for it's speed and I can do most stuff with it. In addition I also trigger my scripts from scheduled tasks, especially the one that cleans up all user-related AppV keys in HKLM. I've modified the tasks to allow them to pass parameters, and the tool I wrote accepts these parameters to find out which user triggered the logoff event and then does its thing. Funny to see how there are so many ways to basically the same solution.

What I don't exclude though is the AppData\Roaming\Microsoft\AppV\Client\Catalog directory. Actually I have been successfully trying to eliminate the 'white icon' issue. An important part of our user-experience is fast login times. They and I don't want all kinds of things to run, I want to be able to login and start my applications right away. I've been succesful in doing so - leaving the right stuff in opposed to excluding it makes logging in blazing fast and applications start immediately. I only have to find out when assignments have changed, because then I will have to do a 'complete sync'.

Anyway, for stability reasons I will first walk through your blog again and apply it to my test environment and see how that goes. I will keep you informed, and thanks again, your blogs might prove a good one for me.

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

I will concede that moving from a closed VFS to a state-separated NTFS-based one created a learning curve - especially for user data.What we have found is the various profile management solutions can vary and how they handle items.

I will also concede that when the user data for an application was encapsulated into one location as a PKG file, it simplified incorporation.

Remember that the AppV Catalog and Package Data are still separate - but the applications file\registry info is also separate with the files using NTFS and the registries using the real registries: This is the concept of the CoW in play. be mindful of all CoW locations in both the registry and the file system.

I find that Registry CoW data is often forgotten in roaming scenarios. I try to spell out these importations here:

http://blogs.technet.com/b/gladiatormsft/archive/2015/04/17/app-v-5-on-the-app-v-5-virtual-registry.aspx

Also check out this white paper:

https://technet.microsoft.com/en-us/library/dn659478.aspx

Hope this provides some clarity.

Steve Thomas, Senior Consultant, Microsoft

App-V/MED-V/SCVMM/Server App-V/MDOP/AppCompat

http://blogs.technet.com/gladiatormsft/
The App-V Team blog: http://blogs.technet.com/appv/
The MED-V Team Blog: http://blogs.technet.com/medv
The SCVMM Team blog: http://blogs.technet.com/scvmm/

"This posting is provided "AS IS" with no warranties, and confers no rights. User assumes all risks."

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

Office 2013 Colour Schemes

I have just installed Office 2013 and concur with all the complaints about the available colour schemes. After only a few minutes my eyes were starting to complain. My intention was to install on 4 machines but I will now defer that option until this problem is resolved. None of the color schemes offered are acceptable on a Desktop PC. Man has been to the moon, surely adding some more suitable colour options for users of this product is a simpler task and not beyond the capabilities of those charged with supporting Office 2013, or is Microsoft not going to listen to the large number of users who are complaining and even abandoning the product!

Changed type Jaynet Zhang Friday, February 15, 2013 9:25 AM

Reply:

Hi,

We have passed this information to the product group for consideration for a future product or update. We are sorry that at this time we have no other option to change the colors beyond what we has already seen.

Jaynet Zhang
TechNet Community Support

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

Dear,

I do not think continously cut&paste your default answer "We have passed this information to the product group for consideration for a future product or update.." is what we would expect from a professional forum like this. If in large companies I hear Execs opposing to upgrading to office2013 beaucse of the lack of options to change colour schemes apart from three shades of grey and them facing potential OHS complaints from medical staff and/or employees, I would not hesitate one second and escalate this up to the level of Balmer. You cannot continue to ignore these valid remarks provided by (so far) very loyal users. I think 99.9% of Office use is on corporate /academic / private desktop computers not on a tablet. Quite honostly on my 3 - 26 inch expensive monitors the least I want is a boring eighties style interface that might (I say might) work on a tablet. In my environment (professionally and privately) I hear nothing but complaints about this dreadful interface (and it's inability to be changed). I cannot imagine that "I will de-install and go back to Office 2010" or : " I will not upgrade" is the kind of response you might want from your most valuable existing user base. I think there is a lot at stake for your Office business unit so if I where you I would take these signals extremely serious and not wait even a week to provide additional templates so that you can put your existing hughe Office user base back in their comforrt zone or there might be no further real future for this product. The future of office is still on a desktop, not a a tablet or surface that (at current) nobody buys.

Edited by StefanWeckx Friday, February 8, 2013 12:07 PM

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

Hi,

We have passed this information to the product group for consideration for a future product or update. We are sorry that at this time we have no other option to change the colors beyond what we has already seen.

Jaynet Zhang
TechNet Community Support

I love how the moderators jump into these forums and drop some nutty vague form-letter based response from someone not even in the product group that never answers the question - and then just simply disappear with no additional information. No problem is solved. No additional information is gathered.

Jaynet, thanks for trying to respond here, but you are not being helpful at all. What would be helpful is if you would get a member of the Office team on these forums to start answering and dealing with these issues. That's right, go down to their cubicle in whatever campus office they sit and get them to respond to people who have concerns over the product they developed. This silence and proxy responses from people not in the product group just makes the Office team look like total losers.

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

What kind of product testing could have possibly allowed you to come to the conclusion that three unreadable color schemes were a sufficient number of choices? You can choose a wider variety of useless backgrounds but you can't offer a color scheme that makes the entire application more pleasing to use?

I have pretty good vision and find the ribbon nearly unreadable in white, light gray and dark gray. 2010's blue allowed for more separation between the menu items and the ribbon - now it looks all jumbled together.

Did you guys circumvent product testing AND fire your entire UI and useability engineers?

Edited by KevinRSmith23 Tuesday, February 12, 2013 9:33 PM typo

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

Totally agree with all comments. I just don't understand, and am baffled that new color schemes haven't been added. I've written to my Microsoft reps and let them have it.. it's plain awful.

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

You can choose a wider variety of useless backgrounds but you can't offer a color scheme that makes the entire application more pleasing to use?

On the subject of useless backgrounds, whose idea was it to position "busy" grey on white text over the top of the buttons in the top right corner? A bit of embellishment is fine on an otherwise bland page, but please don't position them in areas where the user needs to easily see what's underneath or around them.

Until these simple usability problems are resolved, I won't be recommending that my organisation uses Office 2013. It seems that volunteering to pilot it for them was a mistake.

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

Hi,

We have passed this information to the product group for consideration for a future product or update. We are sorry that at this time we have no other option to change the colors beyond what we has already seen.

Jaynet Zhang
TechNet Community Support

Again with the canned response.. I will keep quoting and reposting this nonsense. Is it that hard for someone to provide a "real" answer ?????

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

I am waiting for the Microsoft response that says:

Hello from Seattle,

The product group has passed information back to you, the people who are using our software, that the future update to correct this obvious oversight will be fully tested and released not later than April 30, 2013. They also thank you for paying for their multi-million dollar homes all over the Redmond area and assure you that they prefer to continue to have you pay for the result of their very customer focused software so they can continue to afford the increased property tax bills they are now paying.

Edited by careys Monday, April 15, 2013 11:31 PM

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

I just finished installing Office 365 and I'm already sorry I did so. The lack of color schemes is the first disappointment, especially since I have a hard time seeing the very light colors or white colored fonts on dark backgrounds. Secondly, I believe all the devices have to be set up under the one user account. Since there is the auto-sync feature for email, this makes sharing among a household of multiple users with at least two devices each not a great feature. I'm not certain I want to abandon my Office 2010 version entirely as yet. I doubt anyone in the house except me will make the switch to 365. But the use of pre-defined and no-option color sets is a definite down side.

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

I just upgraded to Office 2013 and am also disappointed with the grayscale color theme. I may go back to 2010 solely on the basis of the color scheme if a new (or the old color scheme) is not made available for Office 2013 in the next few weeks.

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

Hear, hear. I like keeping up with MS Office, but I fear my eye-floaters are going to make the new moon-coloured Office suite a painful experience. So I'm sticking with Office 2010 until MS get off their arse and start fixing their design mistakes, including capitalized ribbon tab names.

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

Completely agree with ALL of the complaints about the horribly flat white/grey color scheme in Office 2013. As a professional developer for almost 25 years, I was amazed that a company the likes of Microsoft would so dumb down a user interface, such that they have removed all color cues and nuance that help the eye take in all the features of the application effectively. While I like the appearance of the icons, as they are fresh looking, sharp, and easy to see, the color scheme causes the entire screen to appear like one mass of jibberish, with nothing to break of the monotony of all the white/text/lines.

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

I agree completely. I was encouraged to move to MS Office 2013 because it has better links to SharePoint. But the color schemes alone are sending me packing if MS doesn't offer a solution soon. The dark gray is not bad, IF it would stick and stay there everytime I open. It does not. IF it would work across ALL office products that would be better... but NO... you have to change when you go to Outlook, then Excel, then Word, then One Note.... I want the MS tools to SAVE me time and frustration not create it. Please hurry, because I WILL NOT deal with this much longer.

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

This is another blunder by Microsoft. What were you thinking. There is almost no contrast and it make looking at your email incredibly difficult especially when you have 2 or 3 additional mailboxes. Microsoft stop trying to be cool and fix this issue ASAP! We are going blind with these color schemes.

FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS FIX THIS

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

I need help you...

I'm Buy New Server Config HP Proliant ML 150 Gen 9. Inter(R) Xeon (R) CPU E5-2620 v3 2.40GHZ 2400 Mhz, 6 Core (s), Logical Processor(s), Ram - 16 Gb, HDD - 300GB, Raid - 1, OS - 2012,

I'm Install Sql - Sever 2008 R2 Express in this Execute 10000 Record Insert For While loop Pl-SQl Get elapsed Time 43 Sec..

And Same Query Insert Other Simple System (Config - i3 Processor, Ram-4Gb, HDD 250GB) in this execute Got Elapsed Time 2 Sec..

How can Solve this Different Between Hp Server & simple System Elapsed Time ..?

Hoe can Solve Hp Server Get Much time When 10000 Insert Query (While Loop) Execute.?

Regard

Saurabh Mishra. R

Reply:

I'm Install Sql - Sever 2008 R2 Express

And is on the Server, is there also a Express Edition of SQL Server or an other Edition, e.g. Standard?

Express Edition is Limit in resource usage: Max 1 GB Ram, max 1 CPU/4 cores, that can limit the Performance.

Olaf Helper

[ Blog] [ Xing] [ MVP]

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

Please Help me . How Can i increase my SQL Resource Performance. when i 10000 Query Insert Execute.

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

Now I am Install SQl Server 2008 r2 enterprise but Same Problem show me... How can Solve this problem pls Help me..

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

Make sure your databases are attached to the correct instance of sql (enterprise). you can have sql express and enterprise side-by-side but if your database stay on the express instance then it does not help.

Mark as answer or vote as helpful if you find it useful | Igor

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

Previous Sql Express Uninstall and then Install New SQl Enterprise. But same Show Problems....

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

Often laptops and workstations have disk write caching enabled. If you are inserting row-by-row without an explicit transaction, then your transaction log file must be flushed after every insert. So if you are inserting in a While Loop, be sure to use a transaction, so you can wait to flush the log file after the last row.

David

David http://blogs.msdn.com/b/dbrowne/

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

You might be a victim of power saver mode. Do power saver off, update stats and try your query again.

Glad to help! Please remember to accept the answer if you found it helpful. It will be useful for future readers having same issue.

My Profile on Microsoft ASP.NET

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

Thank for Suggestion. Im Provide Bulk sms in this par 10 sec 10000 sms Execute in this Insert Row-by-row Query Because par sms check Condition Balance.

How to Improve My insert Query Profarmation? & How can i use flushed after every insert. row - by - row. Pls Suggest me...

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

Thank for your Reply, i'm try but same show issue... Pls Guide me...

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

Can you please share the query plan for both queries?

Glad to help! Please remember to accept the answer if you found it helpful. It will be useful for future readers having same issue.

My Profile on Microsoft ASP.NET

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

>How to Improve My insert Query Profarmation? & How can i use flushed after every insert.

Post your code and your table definitions (DDL), and we can advise you.

David

David http://blogs.msdn.com/b/dbrowne/

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

2007 -> 2013 coexistence issues

Hello Everyone,

I am currently in the process of setting up coexistence for exchange 2007 and 2013. My understanding is that all the internal URL's from 2007 must be configured to be the same in 2013 and then all the DNS records will be changed to point to the 2013 server. The problem I have run into is that all the internal URL's including the SCP use the 2007 server's name. I am not sure how to proceed, can I just use a new internal URL for the 2013 server and change the SCP? Will Autodiscover then just point my existing clients to the 2013 server? I don't think I can repoint the 2007 servers primary DNS record to the 2013 server without causing multiple issues. I tried to create a legacy dns and changed the 2007 server settings described in http://blogs.technet.com/b/meamcs/archive/2013/07/25/part-1-step-by-step-exchange-2007-to-2013-migration.aspx and I ran into all kinds of mail transport issues. We are also using a Barracuda spam firewall appliance and Cisco IronPort secure email.

Exchange 2007
IP address: 10.0.1.2
Server Computer Name: mlsrv.domain.local
Internal URL's : mlsrv.domain.local
External URL's (only setup for owa): mlsrv.domain.com

Exchange 2013
IP address: 10.0.1.3
Server Computer Name: EX13.domain.local
Internal URL's: ???
External URL's: ???

Thanks,

Reply:

You don't need to set all URLs to point to 2013. This requirement only applies to AutoDiscover. I.e. AutoDiscoverServiceInternalUri and whatever DNS record you have set for autodiscover should be pointed to 2013.

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

I would say is to look at these links:

http://blogs.technet.com/b/meamcs/archive/2013/07/25/part-1-step-by-step-exchange-2007-to-2013-migration.aspx

And the Exchange Deployment Assistant:

https://technet.microsoft.com/en-us/exdeploy2013/Checklist?state=2419-W-AAAEAAAAQACIAAEAAQAAAAA~

I would also like to say, that the native Exchange Mailbox move from Exchange 2007 to Exchange 2013 is an online move, meaning the user stays connected to Exchange until the move request completes and cuts everything over to Exchange 2013. At that point they will receive a prompt to restart Outlook and they will need to restart Outlook to gain access to their mailbox again. While I haven't used a third party tool to perform this work, I would think that the behavior is the same if you use a third party tool.

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread

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

email lost

Dear All ,

i have currently exchange 2013 single server and we lost the power for about 12 hours , after that i have restart the exchange server and unfortunately the email during this time is not exist !!!

is this how it should work or there is something wrong ?

Reply:

Hello

check eventlogs and https://technet.microsoft.com/en-us/library/bb123479.aspx

sorry my english

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

This is the same response as I mentioned on your other thread:

https://social.technet.microsoft.com/Forums/office/en-US/eefed55b-df55-4d37-82b9-0a9ee0d66049/mail-lost-during-exchange-server-down?forum=exchangesvrsecuremessaging

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

Merging informations in a csv file .

Hi folks, i have a csv file and i want to merge the informations in it .

For example the input is like

Name ,   Number, slot
A         , 5               , 7
B         , 1               , 10
C         , 3               , 6
B         , 10            , 2
A         , 9              , 2

And i want to sum up Nb and slot for the same users have

Name, Nb, Slot
A, 6, 6
B, 13, 7
C, 4, 10
D, 4, 13

This is just an example, the file i'm using is with reel usernames and around 1000 rows .

Any help will be grateful , i'm quite new in powershell .

Reply:

Sorry the output is not correct , the correct one is

Name, Nb, Slot

A, 14, 9
B, 11, 12
C, 3, 6

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

$CSV = "Name,Number,slot  A,5,7  B,1,10  C,3,6  B,10,2  A,9,2"    $Data = ConvertFrom-Csv $CSV    $Result = ForEach ($User in ($Data | Group Name)) {   [PSCustomObject]@{   Name = $User.Name   Nb = ($User.Group | Measure-Object Number -Sum).Sum   Slot = ($User.Group | Measure-Object Slot -Sum).Sum   }  }    $Result | ConvertTo-Csv -NoTypeInformation    #Output  "Name","Nb","Slot"  "A","14","9"  "B","11","12"  "C","3","6"

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

This is the easy way:

Import-Csv file.csv |   group -property name |   select name,   @{N='Nb';E={$_.Group | (Measure -Sum Number).Sum}},   @{#add sum for slot}

\_(ツ)_/

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

IPAM not working for DHCP server

Hello,

I have a problem with implementing IPAM.

Here is my configuration:
- DCSRV - DC, DNS
- DHCPSRV - DHCP
- IPAMSRV - IPAM

I went over IPAM configuration steps, GPOs have been created, computer accounts have been associated to the appropriate GPOs.

DCSRV connection works and is in Unlocked state, but DHCPSRV doesn't connect with IPAM. IMAP Access Status is Blocked, DHCP RPC Access Status and DHCP Audit Share Access Status are Unblocked, but Event log Access Status is Blocked. Any idea what is wrong? Ports on firewall are opened.

Thank you!

Best wishes,
Marko

Changed type Tiger LiMicrosoft employee Tuesday, May 22, 2012 1:23 AM

Reply:

Hi Marko,

Thanks for posting here.

> DCSRV connection works and is in Unlocked state, but DHCPSRV doesn't connect with IPAM.

> but Event log Access Status is Blocked

Have we verified the membership of 'Event Log Readers' security group and the corresponding remote management firewall rules enablement(Remote Event Log Management (RPC) and Remote Event Log Management (RPC-EPMAP))?

Understand and Troubleshoot IP Address Management (IPAM) in Windows Server "8" Beta

http://www.microsoft.com/en-us/download/details.aspx?id=29012

Thanks.

Tiger Li

TechNet Community Support

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

Hello,

it was the firewall problem.

Thank you!

Best wishes,

Marko

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

Hello Marko,

if you have IPAM installed and the first Server discovered, the possibility exist that the GPO was not proceed in a short time. The following means:

- the IPAM GPO configure the Firewall, so DHCP server and IPAM server can communicate
- if the GPO is not run " default GPO update schedule 90min +- , no Firewall Role is automatically adjusted

in some situation the GPO creates the task but the task cannot run if global PowerShell execution policy is set to unrestricted. in this case, no IPAM-GPO created task will be run ever, you can check this in the task scheduler. the reason for that is, the command line insight the scheduled task is the problem , the Task will be run the command " PowerShell.exe -execusionpolicy BYPASS ..." that create a Error, because the System "global" Execusionpolicy cannot overwritten by the command line setting.

we have found some strange addiction.

the solution from Tiger Li is the manual way to solve the problem, the right way should be that the GPO update must be run on the discovered Server. GPUPDATE on the DHCP server would have already helped.

Rgds

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

Hello,

A colleague and I spent a few hours on this one after receiving all of the same symptoms described above. After verifying all of the GPOs, group membership, and security permissions we noticed the Windows Event Log Collector service was set to manual and stopped.

We starting this service, and then unchecking/rechecking the DHCP option in the IPAM management console the server status switched to unblocked.

If you're receiving a similar error, and notice the 'access denied' warnings in the event log try checking this service.

Hope this helps.

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

I am also having a field day with IPAM. I found out alot of "funny" things. I looked in my AD at the group called IPAMUG and found out that both my domain controllers where there. So I am guessing that the IPAM server also has to be registered in the group. Next I checked the share for the DHCP logs. If you look at the share settings the documentation states that it should be shared to IPAMUG. But the security settings in folder security didnt have any IPAMUG group registered. So I added this and it started to work!

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

solved it! the reason of this problem is the DHCP group policy dosn't apply to DHCP server. you can go to group policy & see the delegation tab of "IPAMx-DHCP" & add the computer account of dhcp server to list. check that enroll permission must set on Allow.

type gpupdate /force on dhcp server.

Regards

Hadi Hashemi

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

Tray icon is not showing up == no toast on mitigation

Hello,

We've deployed EMET on about 40% of our in-house PCs and a vast majority, although having at first, no longer have the EMET Agent tray icon showing up in the Notification Area/System Tray. Because of this, users are not alerted when a mitigation has taken place, and an event is not logged to the event log. To note, EMET_Agent.exe has started and the GPO for Reporting to Event Log, Tray Icon and even Early Warning are enabled.

Any idea why the tray icon wouldn't be showing up?

Thanks,

Matt

Whoops... always useful to make sure that the "EMET Agent Visibility" policy is set to disabled if you want the EMET Agent visible.

Edited by mbrownnyc Thursday, May 28, 2015 1:41 PM
Changed type mbrownnyc Thursday, May 28, 2015 1:41 PM

The Integrated Windows authentication endpoint is missing on the internal metadata document.

Hi,

Using the Remote Connectivity Analyzer, I'm getting the following error when testing SSO:

Analyzing the ADFS metadata document for configuration problems.
    Errors were found while analyzing the ADFS metadata document.
         Additional Details
             The Integrated Windows authentication endpoint is missing on the internal metadata document.

I have followed the kb articles related to this:

https://support.microsoft.com/en-us/kb/2712957

https://support.microsoft.com/en-us/kb/2647048

I checked all the AD FS endpoints, and I "repaired" the domain. Any idea what else it could be?

Thanks, Chris

Changed type Frank Shen5 Wednesday, June 10, 2015 8:17 AM Redirected

Reply:

Small addition: here's the part of the /adfs/services/trust/mex document that describes windowstransport:

        <wsdl:port name="CustomBinding_IWSTrustFeb2005Async" binding="tns:CustomBinding_IWSTrustFeb2005Async">
           <soap12:address location="https://infosys-c1-dc.performisonline.ch/adfs/services/trust/2005/windowstransport"/>
           <wsa10:EndpointReference>
               <wsa10:Address>https://infosys-c1-dc.performisonline.ch/adfs/services/trust/2005/windowstransport</wsa10:Address>
               <Identity xmlns="http://schemas.xmlsoap.org/ws/2006/02/addressingidentity">
                   <Upn>infosystem@performisonline.ch</Upn>
               </Identity>
           </wsa10:EndpointReference>
       </wsdl:port>

What I don't understand is the part where it says <Upn>infosystem@performisonline.ch</Upn>. I compared this to the /adfs/services/trust/mex document of a working installation. There I don't have the <Upn> element, instead I have a <Spn> Element containing the host name of the ADFS server.

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

Please consider asking them here: https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=Geneva

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

Ahmed MALEK

My Website Link

My Linkedin Profile

My MVP Profile

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

Thanks a lot for the pointer, I will do that.

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

[Forum FAQ] Create a task list view without timeline using Server Object Model in SharePoint 2013

Introduction:

Need to create a task list view without displaying the timeline using Server Object Model(C#) in SharePoint 2013.

Solution:

We can create a task list view without the timeline from UI by default, but in code, we need to set ViewData property of the SPView object to empty to achieve this.

The code snippet as below:

using (SPSite site = new SPSite("http://sp2013sps/"))  {   using (SPWeb web = site.OpenWeb())   {   SPList list = web.Lists["TaskList"];     SPViewCollection allviews = list.Views;   string viewName = "Test View";     System.Collections.Specialized.StringCollection viewFields = new System.Collections.Specialized.StringCollection();   viewFields.Add("Checkmark");   viewFields.Add("LinkTitle");   viewFields.Add("Due Date");   viewFields.Add("Assigned To");     string myquery = "<where><gt><fieldref name='ID' /><value type='Counter'>0</value></gt></where>";   allviews.Add(viewName, viewFields, myquery, 100, true, false);     SPView view=list.Views[viewName];   view.ViewData = "";   view.Update();   }  }

Result:

Please click to vote if the post helps you. This can be beneficial to other community members reading the thread.

Reply:

Hello,

Good one!

To avoir any misunderstanding can you just update the code of the query to reflect the case sensitiveness of CAML from

string myquery = "<where><gt><fieldref name='ID' /><value type='Counter'>0</value></gt></where>";

string myquery = "<Where><Gt><FieldRef Name='ID' /><Value Type='Counter'>0</Value></Gt></Where>";

Best regards, Christopher.
Blog | Mail
Please remember to click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.
Why mark as answer?

Edited by Christopher ClementEditor Thursday, May 28, 2015 7:46 AM typo

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

sharepoint admin blogs

hi,

i need some sharepoint admin blogs for issues and improving knowledge.

thanks,

sri

Reply:

Hi,

I have included a few blog links below that I read :

Maurice Prather http://www.bluedoglimited.com/default.aspx

Andrew Connell http://www.andrewconnell.com/blog

Spence Harbar http://www.harbar.net

Heather Solomon http://www.heathersolomon.com/blog

Todd Klindt http://www.toddklindt.com/default.aspx

Todd Baginski http://www.toddbaginski.com/blog

Todd Bleeker http://bit.ly/edlSm5

Jan Tielens http://weblogs.asp.net/jan

Patrick Tisseghem http://www.u2u.info/Blogs/Patrick/default.aspx

Wictor Wilen http://www.wictorwilen.se

Ted Patisson http://blog.tedpattison.net/default.aspx

Lars Fastrup http://www.fastrup.net

Carsten Keutmann http://keutmann.blogspot.com

Keith Richie http://blog.krichie.com

Bill Baer http://blogs.technet.com/b/wbaer

Sahil Malik http://blah.winsmarts.com

Bil Simser http://weblogs.asp.net/bsimser

Ivan Sanders http://msmvps.com/blogs/ivansanders

Gary LaPointe http://blog.falchionconsulting.com

Shanon Bray http://shannonbray.wordpress.com

Cheers,

-Ivan

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

HI Sri,please check the blog for more details on Installation,Updates,Search,Service applications and The solutions for the issues occurred in sharepoint.

http://expertsharepoint.blogspot.de

Anil Avula[Partner,MCP,MCSE,MCSA,MCTS,MCITP,MCSM] See Me At: http://expertsharepoint.blogspot.de/

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

SQL Server 2016 CTP 2 is available

Hello community,

The new SQL Server 2016 CTP 2 is now available as a public download at: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

I wish much fun with testing the new features: What's New in SQL Server 2016

Olaf Helper

[ Blog] [ Xing] [ MVP]

Specific Column is not Searchable in SharePoint 2010

Hi,

I have a SharePoint site, and a list we are not able to get search results for one Column content in a list, for other columns in the same list I am able to search the content. Help me if you have any thoughts.

Reply:

Ib Search service application, Check if the column is mapped to any managed property or not. To appear a column in search results, it should be mapped to managed property. Usually, Sharepoint does that automatically, still worth a try.

Thanks,

Ved

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

Check you have mapped the managed properties.

https://technet.microsoft.com/en-us/library/ff621097(v=office.14).aspx

It's only automatic for site columns, not columns added directly to a list.

Paul.

Please ensure that you mark a question as Answered once you receive a satisfactory response. This helps people in future when searching and helps prevent the same questions being asked multiple times.

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

Hi,

Is this issue happening on this particular site and is that a custom column?

You can check the Searchable Columns option under site settings and If possible, you can try to reset the index, and re-start a full crawl.

Regards,

Reema Bhingarde

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

Whats best method to transfer SQL data from multiple DB servers' site to a central DB over the internet

I am looking for the best method to transfer SQL data from multiple DB servers' site to a central DB over the internet

Reply:

One time or on-going?

Andy Tauber
Data Architect
The Vancouver Clinic
Website | LinkedIn

This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

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

On-going.

Would require simultaneous data upload/push from multiple remote sites 500+ (hosting SQL 2008 Servers/IIS) to a central repository hosted at an internal network DC via DMZ. Data size of required fields from the DB tables for each site would approx. be 5mb and the format can take form of xml or csv as exported from the SQL DB. Need a design that would provide reliability, integrity and scalability of the infra setup.

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

SBS 2011 "windows console wont start

I tried to repair it however is says to insert the sbs CD. SBS 2011 was installed using a file downloaded from Microsoft. which is stored on an off line back hard drive.

I am on vacation is there another way around this, our mail server is down

Thanks

Reply:

Hi:

Are you sure it is not asking for the SBS Recovery/Repair DVD?

For either, if you have the ISO file you can create the DVD or one of your co-workers can.

But for the mail being down review the event logs and the ESM to see what might be the underlying issue. In Services make sure all the services are started.

Larry Struckmeyer[MVP] If your question is answered please mark the response as the answer so that others can benefit.

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

yes my apologies, the sbs 2011 was a downloaded file we never got a repair download that I am aware of

Thanks

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

Hello Ian,

Question is Why do you want to repair SBS ? What went wrong that you are taking this particular step? Could you please explain the issue in detail, so that we can provide you a netter solution. Mail server is down, is it like dead, not booting up ? Crashing ? Unable to send and receive emails with the server being up. etc !!!

If incase of any queries give me a call - 214-347-7988

Binu Kumar - MCP, MCITP, MCTS , MBA - IT , Director Aarbin Technology Pvt Ltd - Please remember to mark the replies as answers if they help and unmark them if they provide no help.

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

Sparten - Open all favourates in a folder

Is there a way to open all favourites in a favourites folder as you can in IE?

I have a folder of all my standard web pages in IE, clicking the right arrow when you hover on the folder opens each in a separate tab.

Changed type Michael_LSModerator Tuesday, June 9, 2015 2:38 AM

Reply:

Hi Paul,

Thanks for the feedback.

It seems that in Spartan, right click the folder, then choose to open in New Tab under Favorites could only open the lasted saved page.

Please take use of the Feedback Tool to submit what you suggested.

Regards

Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

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

Unable to install MSXML 6 SP2 (KB973686) setup was interrupted

Hi,

I tried several times to install MSXML 6 SP2 version 6.20.2003.0, which is the minimum supported version for installing a program that we desperately need, and no matter what we try, we always get the same error:

MSXML 6 SP2 (KB973686) setup was interrupted
Setup was interrupted before MSXML 6 Service Pack 2 (KB973686) could be completely install.

Current operating system: Microsoft Windows Server [Version 6.0.6001]
Current MSXML6 version: 6.20.1099.0

I've tried to search for a solution and despite the many threads mentioning the use o Windows Installer CleanUp Utility to remove MSXML 6. I executed the cleanUp Utility and nothing happens since the tool does not detect the installation.

So basically I'm stuck

Regards
RG IT Department

Edited by rjbgaspar Wednesday, May 27, 2015 12:38 PM
Changed type Vivian_Wang Friday, May 29, 2015 9:18 AM

Reply:

Might try over here.

https://social.msdn.microsoft.com/Forums/en-US/home?forum=xmlandnetfx

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

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

FYI Rebuilt

Not mentioning for any particular reason...

Just completely & totally rebuilt my 8.1 this afternoon. The front yard, the back yard, the garage, the whole house all back to the status quo

All systems, now, 'good-to-go', again. Yea! Had to do 8.0 first & then 8.1 to finish the install.

Cheers,
Drew

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

Build 10130 is released.

http://blogs.windows.com/bloggingwindows/2015/05/29/announcing-windows-10-insider-preview-build-10130-for-pcs/

Deduplication file cloning

Take a golden generalized VHDX, with the intention of creating a few billion copies of it. Can this be done in a few milliseconds with deduplication, using no additional space until the VM's are launched? I was googling for this feature and it is described as a btrfs feature in an Arstechnica article, and this is the command in btrfs:

me@server:~$ cp --reflink=always 200GB_virtual_machine_drive.qcow2 clone_of_200GB_virtual_machine_drive.qcow2

Changed type MedicalSMicrosoft contingent staff Monday, June 1, 2015 8:59 AM

Please help! Godaddy Domain Provider Information/Access Credentials Cannot Be Verified

For the past week, I have been having a problem with SBS 2011. My Godaddy account cannot be verified under Internet domain name properties. This has ceased me from setting up my internet address and website/sbs 2011 sharepoint servers and email.

The Domain Name Properties Page (Click Network, Connectivitiy, My domain "remote.xxxx.com", View Internet Domain Name Properties [right hand column under "Tasks/Domain Name Tasks"]

Batch Script open IE with last browsing session.

Hello,

I have created a simple script to close IE, run ipconfig, release flushdns, renew, the open IE again.

This works fine. IE normally prompts the user to restore browsing session.

Is there a way to open the last session without prompt from IE? Automatically in the batch?

Anyone have anything else useful to add?

Many thanks

andy

Andy Walker

Changed type Bill_Stewart Thursday, July 9, 2015 4:52 PM
Moved by Bill_Stewart Thursday, July 9, 2015 4:52 PM User should not be doing this

Reply:

Post in IE developer forum for info.

On the IE options start page tab select the button "Start with tabs from the last session". This will cause IE too open with previous tabs.

\_(ツ)_/

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

You can also set this value:

(get-itemproperty HKCU:\'Software\Microsoft\Internet Explorer'\ContinuousBrowsing).Enabled

\_(ツ)_/

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

aye aye but can I script it?

id "rather" ie opens with home tabs in normal operation,

If the user has to run this script to give ie a kick in the face due to a hang then id rather it reopened with the tabs it closed with.

thanks for your help

Andy Walker

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

@ECHO OFF
echo.
echo.
echo STEP 1: Closing Internet Explorer . . .
echo.
echo.
TASKKILL /F /IM iexplore.exe
echo.
echo.
echo STEP 2: Flushing the DNS . . .
echo.
echo.
ipconfig /release
ipconfig /flushdns
ipconfig /renew
echo.
echo.
echo STEP 3: Starting Explorer . . .
echo.
echo.
start iexplore.exe
echo.
echo.
echo Completed: Internet Explorer cleaned and running.
echo.
echo.
PAUSE

Andy Walker

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

What is the purpose of doing this?

-- Bill Stewart [Bill_Stewart]

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

Driver_IRQL_not_less_or_equal FIX

If your machine suddenly wants to restart due to "having a problem" and w/ Drive_IRQL_not_less_or_equal on a light blue screen, here is the FIX:

Cheers,
Drew

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

Reply:

Obviously copied from another source. When doing this its good form to credit the original author.

Jerry

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

The same instructions can be found from several sources. In this case happened to be from Tom's Hardware.

Cheers,
Drew

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

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

HOWTO: Getting 5K quality from 5K iMac to Windows 8 via RDP

This is for those of you with a 5K iMac trying to connect to a remote Windows 8 box at near 5K resolution. If anyone has any improvements to this process (ahem, Microsoft), please share.

Caveats:

The cursors will be absurdly large. I haven't figured out a way to fix this.
It's a pain in the ass procedure, so hopefully you're staying connected most of the time.
This will probably be too annoying to deal with if you're regularly connected to Windows machine in person, since you'll have to keep changing the scaling modes around and signing in/out.
MICROSOFT: Please make the RDP app work better when connecting from a 5K iMac!

One time setup:

Install Microsoft Remote Desktop for Mac on a 5K iMac.
Setup your connection to your Windows 8 box, choosing "Native" resolution and "Full screen mode" of "OS X Native." Check all 3 buttons at the bottom: Start session in full screen, Scale content, and Use all monitors.
Install Display Menu (free app in the Mac App Store), and consider upgrading with in-app purchase as it'll save you time when switching resolutions back to Retina later.
On the Windows 8 computer, right-click on the desktop, choose Screen Resolution, click on "Display" in the top navigation bar to jump up one level, and change the scaling to 200%. If you don't see that option, check the box for "Let me choose one scaling level for all my displays." Let it sign out and back in. (NOTE: Obviously if you're not near the computer you'll need to do this step via RDP, but it's still just a one-time thing, assuming you're not regularly connecting to your PC in person.)

When you want to connect to Windows at 5K quality:

Using Display Menu, set your resolution to 5120x2880.
Connect to the Windows 8 computer via RDP.
Once connected to Windows, you can return the Mac to normal retina resolution: If you've upgraded Display Menu to the Pro version, choose the "2560x1440" option from Display Menu to return your iMac to normal retina mode. If you didn't upgrade, you can accomplish the same thing by opening System Preferences, then Displays, then choose "Default for display" instead of Scaled.
OPTIONAL: If everything looks great on your Windows connection, you're done. If everything looks giant, you may need to select "Scaled" from the RDP menu to get it to scale correctly.

When you're done with these steps, you should be looking at 5K quality on your remote windows desktop, albeit with absurdly large pointers/cursors.

Edited by TomTomTomTomTom55 Friday, May 29, 2015 6:09 PM

Windows 7 Backup and Restore won't display

I don't know how else to describe this but with a picture. When I open Backup and Restore on my windows 7 pro computer it shows the image below. Any suggestions would be helpful.

Reply:

Have a look : http://www.sevenforums.com/backup-restore/114415-windows-7-backup-restore-blank-screen.html

Arnav Sharma | http://arnavsharma.net/ Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

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

I had the Windows Backup service turned off for some weird reason. I enabled it and it looks to be working. Thanks for the help.

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

Surface 3 Power issues

My surface 3(build 10041) seems to be having quite a bit of power issues like:

Not shutting down when I tell it to shut down then draining the battery to 0%
Terrible battery life. Fans always running, some kind of process is just eating up the cpu usage. with no applications running.
Can't wake up from sleep: Using the lock(power on the top) button won't allow it to wake up after awhile. I have to pretty power button plus volume several times.
After shutting off the display with the lock button, the screen turns back on after a second.

Anyone else experiencing these issues?

Edited by slycoder127 Thursday, March 26, 2015 7:52 PM

Reply:

I am having the exact same issues, will keep an eye on this thread.

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

well at least I know I'm not alone. Hoping for a response from devs :)

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

The SP3 should have some power config reports you can pull using the command line or powershell

try something like this with admin privileges:

powercfg /batteryreport /output %tmp%\battery-report.html

the reports you generate should give you a good idea of what's using the most amount of power etc.

Also, the SP3 is setup to be in a standby connected state for 4 hours after you close the keypad or shut it off as you can click the end of your pen's button to wake the device, after the 4 hours of standby connected state it should shut down if you haven't told it otherwise, if anything is in between the the touch screen and the keyboard it may prevent it from shutting down as well.

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

I'm using hyper v also so I think that messes with connected standby

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

I too having this problem so I did as you suggest here, I looked into the battery report and it said lockapphost had used 50% of the battery over night.

It seems to me that windows 10 will not let the surface go into full sleep at any point.

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

Incorrect SQL 2014 SP1 version at the Eval Center

Just wanted to let you guys know that even when selecting the x64 download of SQL 2014 SP1 version at the Eval Center, you still get the x86 version (SQLServer2014SP1-FullSlipstream-x86-ENU.iso).

The quick workaround is of course just to change the URL to ...SQLServer2014SP1-FullSlipstream-x64-ENU.iso but it would nice if the issue could be corrected.

/ Johan

Regards / Johan Arwidmark Twitter: @jarwidmark Blog: http://www.deploymentresearch.com FB: www.facebook.com/deploymentresearch

Changed type Shanky_621MVP Friday, May 29, 2015 10:33 AM not a question

Reply:

Thanks Johan but I guess it would be correct to create connect item for the same. MS employees dont visit this forum too oftem.

Anyways there was problem with SP1 for 2014 I guess its still not fixed

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Wiki Article
MVP

Edited by Shanky_621MVP Friday, May 29, 2015 10:32 AM

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

Anyways there was problem with SP1 for 2014 I guess its still not fixed

No, it is fixed and re-released on May 14th
https://support.microsoft.com/en-us/kb/2958069
http://www.microsoft.com/en-us/download/details.aspx?id=46694

Olaf Helper

[ Blog] [ Xing] [ MVP]

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

Applying Filters on DNS Queries using Windows DNS Server Policies

http://blogs.technet.com/b/networking/archive/2015/05/18/applying-filters-on-dns-queries-using-windows-dns-server-policies.aspx

DNS policies can be used to create query filters based on certain criteria. One of the example of such filters are DNS black holes for known malicious domains. Another example is to create a whitelist to allow only a specific set of clients to resolve certain names. The filters can be created with any logical combination (AND/OR/NOT) of the following criteria.

Name	Description
Client Subnet	Name of a predefined client subnet. Used to verify the subnet from which the query was sent.
Transport Protocol	Transport protocol used in the query. Possible entries are UDP and TCP.
Internet Protocol	Network protocol used in the query. Possible entries are IPv4 and IPv6.
Server Interface IP address	IP address of the network interface of the DNS server which received the DNS request
FQDN	FQDN of record in the query, with the possibility of using a wild card.
Query Type	Type of record being queried (A, SRV, TXT etc.)
Time of Day	Time of day the query is received.

Changed type Kumar Ashutosh ShrivastavaMicrosoft employee Friday, May 29, 2015 10:01 AM

How to build a Pivot Table with 3 Row Totals

The Table is Below:

Country	Project Num	Developer	Dc13	Ja14	Fb14	Mr14
India	IND 10	John Doe	240	240	240	240
India	IND 1	John Doe	120	120	120	120
India	IND 11	John Doe	1200	1200	1200	1200
India	IND 30	John Doe
India	IND 29	John Doe
Tanzania	TAN 1	John Doe				240

Desired Result:

Totals	Jan-14	Feb-14	Mar-14
Unique Countries	1	1	2
Total Projects	4	4	4
Total	1560	1560	1800

install and setup FTP in Windows 7 from command line

I want to do the following things from command line in Windows 7.

1. Enable IIS and FTP. The command in the following link installs only the IIS: http://www.iis.net/learn/install/installing-iis-7/installing-iis-from-the-command-line

2. Create ftp site and edit bindings as well

Thanks,

Lina :)

Moved by Paul E Long Thursday, May 28, 2015 4:14 PM
Changed type Vivian_Wang Friday, May 29, 2015 9:02 AM

Reply:

Hi,

Thanks for your post.

It seems like the issue is more related to IIS. I suggest you could ask in IIS forums:

https://forums.iis.net/

Regards.

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

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

Converting Word to PDF

I don't really have a question. I just wanted to take the time to acknowledge whoever designed the system that lets us use the "Save and Send" option to turn the word document into a PDF. The code is so efficient that when we click "Send File as PDF" it automatically opens a new email in outlook with the word document converted into PDF as an attachment. The funny thing is that this transformation is actually quicker than the one available in the Print to PDF option in the print section. Cudos to whoever deserves the credit.

Changed type William Zhou CHN Monday, April 2, 2012 7:07 AM Gerneral Discussion

Send-MailMessage : Unable to connect to remote server Line 1 character 17 error in PowerShell 2.0

After running below code

Send-MailMessage -to "c-druparel@pa.gov" -from "c-druparel@pa.gov" -Subject " Test message" -Body " Test message" -SmtpServer " 172.18.183.66"

If you run into error given below

Send-MailMessage : Unable to connect to the remote server
At line:1 char:17
+ Send-MailMessage <<<< -to someone@somedomain.com -from "DhimantR@someDomain.com" -subject " Troubleshooting" -Body "Some Text or file attachement" -sntpserver "smtpserver"
+ CategoryInfo : InvalidOperation: (System.Net.Mail.SmtpClient:SmtpClient) [Send-MailMessage], SmtpException
+ FullyQualifiedErrorId : SmtpException,Microsoft.PowerShell.Commands.Send MailMessage

Try this solution

Solution: one of the possible problem is your anti-virus software blocking to connect SMTP server using PowerShell

In my case it is McAfee

Steps:

Right click on McAfee icon
Click on Virus Scan Console
Double click on Access Protection on VirusScan Console
On Access Protection tab
Go to Anti-Virus Standard Protection
On right hand side, double click on Prevent mass mailing worms from sending mail
On process to exclude tab, add PowerShell.exe at the end
Click ok
Click apply on Access Protection
Click ok

That's it and try again to send mail using Send-MailMessage

Dhimant

Moved by Script Explorer Administration Friday, June 14, 2013 4:25 PM

Reply:

one of the possible problem is your anti-virus software blocking to connect SMTP server using PowerShell

Steps:

Right click on McAfee icon
Click on Virus Scan Console
Double click on Access Protection on VirusScan Console
On Access Protection tab
Go to Anti-Virus Standard Protection
On right hand side, double click on Prevent mass mailing worms from sending mail
On process to exclude tab, add PowerShell.exe at the end
Click ok
Click apply on Access Protection
Click ok

That's it and try again to send mail using Send-MailMessage

Dinesh S.

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

Fixed my issue.

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

thank's ,solved for me.

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

This was perfect. Fixed my issue. Because I was using the ISE, I also had to add PowerShell_ISE.exe to the exclusion list.

Thanks a million!

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

Thanks It worked for me

ManojK

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

Windows Classic Theme Elminated along with Windows XP and Windows 7 Themes?

I know Microsoft has been focusing more and more with it's 3D and Touch Screen Functions and Windows Metro which seems to be a HUGE Focus in Windows 10, and I know Word Microsoft is not revealing why the Themes of "Windows Classic" "XP" and "Windows 7" was eliminated except some at TechNet reported Crashes that used those themes, and old bug that remained from Windows 7 that kept Crashing the Desktop Windows Manager, as a result those themes are Eliminated and the Service can not be disabled, Is there Ever likely a Chance the Management at Microsoft will restore the Themes of Windows Classic" "XP" and "Windows 7" to be restored in the Future when more Bug and Security Corrections are made to those 3 themes?

Changed type Michael_LSModerator Tuesday, June 16, 2015 2:21 AM feedback

Reply:

We can dream.

Microsoft seems to be turning Windows into something that resembles Office 2013, without options.

I don't know - nor can I imagine - what advantage it is to them not to provide user-selectable themes. Maybe it just makes the Metro/Modern subsystem look less poorly integrated, I don't know. But what they're doing is on purpose, and it DOES reduce usability.

Does anyone - could anyone- really think having flat-colored, square-cornered buttons and controls somehow makes them easier to use?

Microsoft doesn't realize how much people care about how their desktops look and feel, and if their goal is to win the hearts and minds of Win 7 "holdouts", the way to do it is not to propose "you can have any color you like as long as it's white".

-Noel

Detailed how-to in my eBooks:

Configure The Windows 7 "To Work" Options
Configure The Windows 8 "To Work" Options

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

Well, that is hard to say.

But we could submit our suggestions using the Windows Feedback Tool.

Updates and feedback

Regards

Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

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

Excellent advice, Michael, and rest assured already done by me (as well as logging "Me Too" on appropriate suggestions).

I have just recently heard some good things from those running leaked builds. I don't partake, but I do hope that Microsoft listened when many thousands of insiders pining via the Feedback App for the return of a nice Aero Glass theme choice.

-Noel

Detailed how-to in my eBooks:

Configure The Windows 7 "To Work" Options
Configure The Windows 8 "To Work" Options

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

Recommendation for archiving projects / 5000 limit

Considering the use of Project Online only (not project server 2013), how would you recommend getting around the 5,000 project count limit ? I need to make sure my organization can have a record of projects that completed, and some information about them like the name, major dates, and other high level information like planned start/planned finish, actual start/actual finish, planned hours, actual hours, etc... along with timesheet data about who tracked how much time to what tasks when.... all that should hopefully be maintained. Is that a possible scenario today? Or do we just hope that by the time we hit 5000 projects that Microsoft has raised, or removed that limit... or introduced archiving? I suppose an alternate solution is to export all the information we'd like to report on to another reporting service, but that kind of defeats the purpose to having one tool / one pane of glass for the solution, no?

Ian

Changed type Ian Bruckner Wednesday, May 27, 2015 9:04 PM

Reply:

Hi Ian,

I would suggest to write down a procedure for archiving projects. It could be for example as following:

in a first step, you flag the completed projects as "completed' through a project custom field, you lock and unpublish all tasks, you add the project into an "archived" security category.
in a second step, you could delete year-1 "archived" projects from the draft/publish DB and only keep them in the archived DB.
in a third step, you could totally delete year-2 projects from the archived DB and keep a local copy on a shared repository.

Keeping a report is another solution.

Hope this helps,

Guillaume Rouyre, MBA, MVP, P-Seller |

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

Thank you for the reply, Guillaume. Unfortunately it is my understanding that no such ability exists in Project Online. Unless I am mistaken, the strategy you describe requires Project Server.

Regarding keeping a report... my intent is not to just export a static report about a project that can be viewed later. Instead, I would like the ability to pull reports across projects and across my organization... Things like, "where did all the time go in FY 2015" (by project, resource type, individual, etc), "What projects had actual hours that were close to their estimated hours, or the other way around", "What projects did we do for Department XYZ in years 2015, 2016, 2017", "How many projects did each person work on during a timeframe", or any number of other things executives would want to know, or that the PMO would like to know so that we can help ourselves and our organization get better, promote what we've done well, and otherwise have a historical record of the work we've done... in a format that's interactive. Today I can't imagine what type of report an executive will find useful in 2018, but if I delete the data today, I'll never be able to pull it for the executive tomorrow.

Ian

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

Hi Ian,

Indeed just the steps 1 and 3 are applicable for Project Online.

That being said, for keeping the projects historical data, I think that 5,000 projects should cover a reasonable timeframe. If exporting the mpp files as local files does not suit your need, you can always use a 3rd-party tool to migrate the project online data to a Project Server 2013 on-prem development environnment.

Hope this helps,

Guillaume Rouyre, MBA, MVP, P-Seller |

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

Ah, yes, looking back... step one regarding a security approach is certainly accomplishable in Project Online. Thank you for bringing that up... That's a great idea.

However, steps two and three you mention an archive DB. No such thing in Project Online, right?

And you're right, 5,000 should be a reasonable timeframe ;) I suppose by the time we hit that, Microsoft will make some improvements in the limit or we'll have had ample time to move the data to a warehouse.

Ian

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

Yes you're right, no archived DB in Project Online. But you could just delete the project after having saving it locally.

I do agree with you that by the time you'll reach 5,000 projects, Microsoft will probably have reased the limit.

Hope this helps,

Guillaume Rouyre, MBA, MVP, P-Seller |

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

I'm still uncertain about the tie between time reporting and projects. For example, time can be reported at the top-level project if so enabled, and not to project tasks. Further, there exist administrative timesheet entries unrelated (directly) to projects. So if there is a 5,000 limit on projects, and you delete the 5,001st, what information do you lose? If a timesheet had actual time attached to a project, certainly the name of a project could be retrieved? Or does that timesheet information that's tied to a specific project get deleted?

Saving a local copy of the .mpp will allow us to keep information like project name, tasks, schedule, and other attributes about the resources, tasks, and projects... but it would lose the link to the cohesive nature of a common reporting solution, no?

Can you or someone else speak to what we might lose the ability to report on in Project Online if a project gets deleted, and what would we still be able to report on? I'm thinking about the examples I provided in the above comment and now below:

Again, I do understand that 5,000 is a pretty high number... 25 years of 200 projects a year. Maybe we do more or less, but that's a starting point... even if it's only 10 years worth, that's an eternity in which Microsoft could either add functionality or drop out of the PPM market entirely. However, I think it's a good idea to discuss some basic eventualities assuming no changes.

Ian

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

Timesheet and projects are stored in different Project tables. If you delete a project, you will not delete the timesheet entries done against this project. The timesheet entry status will change to "rejected" but the timesheet will remain (project name and all project related datain the timesheet), such as the timesheet actuals.

Hope this helps,

Guillaume Rouyre, MBA, MVP, P-Seller |

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

Thanks, that helps a lot.

Assuming we don't have status updates submitted to project managers, but instead timesheet managers approve the timesheet as a whole, would the approval status really still change to rejected if a project gets deleted?

Ian

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

I would say it will be the same behavior but it should be tested.

Hope this helps,

Guillaume Rouyre, MBA, MVP, P-Seller |

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

Ian,

FluentPro has a solution for Administrative Backup for Project Online - we backup / restore configuration, projects and project sites (http://www.fluentpro.com/project-online/configuration-management/backup-for-project-online/)

With this approach you can delete projects and sites and on-demand restore them from backup.

Let me know if you have questions.

Anton

Products for Project Server 2010/2013: Business Intelligence, Management and Migration. Implementation & custom development. http://www.ProjectServerBlog.com

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

MdxScript (SSAS CUBE) (3998, 1718):The level '&[XXX]' object was not found in the cube when the string, [Version].[Version].&[XXX], was parsed

Hi,

I am new to SSAS development. I come across this error (MdxScript (SSAS CUBE) (3998, 1718):The level '&[XXX]' object was not found in the cube when the string, [Version].[Version].&[XXX], was parsed), when I tried to process the CUBE.

After Analyzing, I have found the reason behind it.

1. The level that I defined in in the MDX script ( &[XXX]) is not available in the Dimension Dim.Version. So when cube is processing it will try to reach the level .&[XXX]. As the level is not present in the Dimension, it throws error that " The level is not found".

Hope it helps to the new MSBI developer who wants to explore the CUBE .

What if scenarios for repairing missing/corrupted files on any Windows partition.

So I have various problems that occur from time to time with corrupted files and other issues that make a previously working Windows partition unbootable. Common lately is failing to load the winload.exe on attempts to boot to a Windows parition. I'm using multiboot system with multiple OS partitons on different individual HDD or SSD's. In my example I have a couple of Windows 7 partitions that do not want to boot with the winload.exe error. I have copied and replaced files already using Robocopy so that both partitions are essentially the same. One is on a HDD and other on SSD. My intention is to remove the SSD once I get it fixed and place it in another computer. It looks like all the files are there and when booted to a Windows 7 install disk and running SFC, it's reporting "No integrity violations found".

I'm pretty sure at this point that the drives are physically OK, and that all files are good but I still get the winload.exe error when I try to boot to them. I've tried booting to safe mode (with and without networking, command prompt etc). On those attempts I get to the screen where Windows 7 is loading, depending on safe mode or not will sometimes get the boot log/drivers loading screen, others just the Windows loading splash screen. What is happening is that it all appears to be working but instead of getting the logon screen next, the computer will just reboot. No BSOD or errors are shown and can't see anything in the logs about it.

I've been through the boot repair options, bootrec, bootsect, bcdboot, bcdedit, etc and appears everything is like it should be. Startup repair from the Recovery Console is indicating that Windows booted as normally. Usually run that at least 3 times. Have ran chkdsk many times using /f /r /v /b options, both together and indepdndently.

I've been wondering what would happen if after I booted to the Windows Install is I just used Robocopy and copied the entire Windows temp directory (default x:\) to the c:\ partition with the Windows install that I'm trying to fix. I typically use this command with Robocopy as I don't necessarily want to delete files on the source or destination partitions until I'm sure what the problem is. Assuming X:\ for the Windows Temp Directory off boot disk and C:\ for active Windows 7 partition that is not booting. for this example I'm thinking of running

Robocopy x:\ c:\ /create /mir /e /s /r:0 /w:0 /xx /xo /eta /v (with maybe /zb)

What would this accomplish? if anything..or any better solution would be appreciated.

Reply:

You need to obtain a disk utility to check the status of your HDD. It is not common for Windows to self-destruct. This situation is normally caused by bad sectors on the HDD and Windows is not designed to cope with defective hardware.

If you don't replace your HDD is will eventually fail completely and you will lose all data on that HDD.

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

I think that after all research I have to attribute it to the hardware of the computer itself. After numerous calls to Dell they are insisting that this computer (Optiplex 760 Mini-Tower) is not able to run Windows 7 very well (actually they said not support and won't run Windows 7). . I don't really believe it, and if so, then Dell is even worse than I thought if they can't have a computer made in 2009/2010 compatible to Windows 7. They state that that system was made for XP and Vista and the original operating System is Windows Vista Business. (I wouldn't know, I got it on a trade after my Opti 755 motherboard shorted out). That still asks the question of what is so different in Win 7 that isnt in Vista? I always thought that if the hardware could support Vista then it would at least support Win 7 also even if there are some minor issues. Dell made it sound like it would absolutely not work with Windows 7 and I know that to be false.

I have asked and tried to find out why a company would release a computer like the Optiplex series in 2009/2010 that wasn't compatible with what would have been then the current most widely used opearating system, Windows 7. I don't ever really believe a word that comes from anyone related to Dell, as they have shown before that they will tell you what they want you to believe and not nesessarily the truth. My Otiplex 755 and Studio 540 are both much older than this Opti 760 and all worked fine with Windows 7 and above.

In addition, the 760 comes with AHCI as the default, standard mode. I did have a version of XP on it for a while, XP 64 bit though, and it was just as plaugued with stop 7B BSOD errors as any other newer computer I've had if you try to run XP in AHCI without other significant tweaks or changes. In fact it is so misengineered that the onboard eSATA port only works when in AHCI mode and if legacy or ATA mode then it's disabled. I still do not understand the reasons what that would be the case, other than Dell just likes to make stupid proprietary modifications to their systems for no other reason than they are spawned from the Devil's toilet. I love how they don't publish those modifications either.

If you really want to waste a weekend, try adding a non WD or Seagate HD or any HD 1 TB or over and try to install it on the Opti755 in particular and the keyboard detection error is on (default). You will get a lovely message, basically indicating that if you didn't get the HD from Dell or don't immediately remove it then your entire system will burst into flames and self- destruct and to call them immediately. Funny enough, if you do call for that reason and with the specific code it gives you, they seem to have no knowledge of such a restriction. (BTW, the fix for that issue is to just simply disable keyboard error detection in bios).

So getting back to this issue.,..the System works fine in ATA mode. Currently have Windows 10 Tech prev in addtion to Win 7 and no issues, just no ACHI. So I'm guessing that it has to do with that SATA mode setting. The HDD's ive used are from Various manufacturers and different models and builds, both SSD and regular HDD. So far this computer has killed 3 drives trying to get it to work smoothly in the default setup. I already have new motherboard and processor, may just use the Opti case but completely rebuilt insides and UEFI bios/mobo.

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

I voluntarily removed what could be offensive (if you work at Dell) And no one asked me, but I saw someone barked it as offensive. Fine. It's edited. A quick Google reveals many others Who have said almost exactly the same thing about This computer in regards to Win 7 and above with AHCI enabled on this model. What I think is more offensive Is this computer manufacturer is still listing this model As Windows 7 compatible yet will tell you if you call Them that it's not for some reason. And yes, drivers , bios, etc were updated and All the other jazz you'd do for troubleshooting.

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

microsoft Intune error

hello
I have a subscription microsoft Intune (evaluation 30 days).
Upon entering Management Console, an error message appears:
Username not recognized
There was an error processing the request.

Anyone have any idea why this happens ??

Reply:

Are you logging in with the admin account that you have setup? username@domain.onmicrosoft.com is usually how the username is setup for Trial tenants unless you have added a domain.

Also have you assigned the licenses?

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

Tuesday, February 1, 2022

How do I sort a Delimited text file by the second delimitation?

How do I sort a Delimited text file by the second delimitation?

Display both married and others in one form

VLAN - Please explain this to me

AppV5 on RDS session hosts - all kinds of issues, am I alone?

Office 2013 Colour Schemes

I need help you...

2007 -> 2013 coexistence issues

email lost

Merging informations in a csv file .

IPAM not working for DHCP server

Tray icon is not showing up == no toast on mitigation

The Integrated Windows authentication endpoint is missing on the internal metadata document.

[Forum FAQ] Create a task list view without timeline using Server Object Model in SharePoint 2013

Introduction:

Solution:

sharepoint admin blogs

SQL Server 2016 CTP 2 is available

Specific Column is not Searchable in SharePoint 2010

Whats best method to transfer SQL data from multiple DB servers' site to a central DB over the internet

SBS 2011 "windows console wont start

Sparten - Open all favourates in a folder

Unable to install MSXML 6 SP2 (KB973686) setup was interrupted

FYI Rebuilt

FYI Rebuilt

Build 10130 is released.

Deduplication file cloning

Please help! Godaddy Domain Provider Information/Access Credentials Cannot Be Verified

Batch Script open IE with last browsing session.

Driver_IRQL_not_less_or_equal FIX

HOWTO: Getting 5K quality from 5K iMac to Windows 8 via RDP

Windows 7 Backup and Restore won't display

Surface 3 Power issues

Incorrect SQL 2014 SP1 version at the Eval Center

Applying Filters on DNS Queries using Windows DNS Server Policies

How to build a Pivot Table with 3 Row Totals

install and setup FTP in Windows 7 from command line

Converting Word to PDF

Send-MailMessage : Unable to connect to remote server Line 1 character 17 error in PowerShell 2.0

Windows Classic Theme Elminated along with Windows XP and Windows 7 Themes?

Recommendation for archiving projects / 5000 limit

MdxScript (SSAS CUBE) (3998, 1718):The level '&[XXX]' object was not found in the cube when the string, [Version].[Version].&[XXX], was parsed

What if scenarios for repairing missing/corrupted files on any Windows partition.

microsoft Intune error

Setup is Split Across Multiple CDs