Tuesday, February 1, 2022

fetch drop down list field from Sharepoint list...

fetch drop down list field from Sharepoint list...

i am having one form (consisting of 3 text boxes and one drop down list)

i want to store all the content in List in Sharepoint 2010.......and the drop down list be populated from the values in

another list.....

how can we achieve that?


Reply:

Hi,

When we want to set another list as source of drop down, you can do as lookup value for drop down. Once we set lookup field, there will be list of existing List in site and we can set any one as source for drop down. Moreover we have choice for setting display field in drop down.

hope this will help you.

Thanks and Regards, Shailesh B. Davara


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

Hello,

follow the below link bind the dropdown list from the sharepoint 

http://stackoverflow.com/questions/1999269/retrieve-sharepoint-list-data-and-bind-this-to-a-dropdownlist

and below link will be useful to add the item in the sharepoint list programatically

http://sharepointjim.wordpress.com/2010/04/21/programmatically-insert-an-item-in-sharepoint-list-using-asp-net-user-control/

Hope this will help to you.

Hiren Patel | Please click "Propose As Answer" if this post solves your problem or "Vote As Helpful" if this post has been useful to you.


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

Thanx... Shailesh and Hiren..

What should i do if i have to select state for respective countries (2 drop down list side by side)


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

Hi,

I have created the two list for that 1)Country , 2) State

State list have lookup column from Country list

to bind the dropdown  of state with  you need to use the caml query for the select countries

in my .ascx file i have used the below code

Country: <asp:DropDownList ID="ddlCountry" runat="server" AutoPostBack="true"   	onselectedindexchanged="ddlCountry_SelectedIndexChanged">  </asp:DropDownList>  State :<asp:DropDownList ID="ddlState" runat="server">  </asp:DropDownList>

in my code behind in page load event i am binding the Country dropdown

protected void Page_Load(object sender, EventArgs e)  		{  			if (!IsPostBack)  				BindCountryDropDown();  }

public void BindCountryDropDown()  		{  			using (SPSite site = new SPSite(SPContext.Current.Site.Url))  			{  				using (SPWeb web = site.OpenWeb())  				{  					SPList list = web.Lists["Country"];  					DataTable dt = list.Items.GetDataTable();  					ddlCountry.DataSource = dt;  					ddlCountry.DataTextField = "Title";  					ddlCountry.DataValueField = "Title";  					ddlCountry.DataBind();  				}  			}  		}
I have enabled auto post back true for the country dropdown so when i will change the dropdown value for the country the in another state dropdown value will get accordingly for the specified country
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)  		{  			BindStateFromCountry(ddlCountry.SelectedValue);  		}  		public void BindStateFromCountry(string Country)  		{  			DataTable dtResult = new DataTable();  			SPQuery query = new SPQuery();  			SPList listState = SPContext.Current.Web.Lists["State"];  			string strQuery = "<Where><Eq><FieldRef Name='StateOfCountry' /><Value Type='Text'>" + Country+ "</Value></Eq></Where>";  			query.Query = strQuery;  			dtResult = listState.GetItems(query).GetDataTable();  			ddlState.DataSource = dtResult;  			ddlState.DataTextField = "Title";  			ddlState.DataValueField = "Title";  			ddlState.DataBind();  		}

Hiren Patel | Please click "Propose As Answer" if this post solves your problem or "Vote As Helpful" if this post has been useful to you.



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

Hiren,

Your solution is close to what I am looking for but bit different as below:

I am creating a custom solution on SharePoint 2013 on-premise using Visual Studio 2012. I have a custom list called Postings. This list have 2 fields - Title (single line of text) and URL (hyperlink). 
I have a drop-down list control which gets auto populated from "Title". I have a button next to this drop-down control. Based upon the selection in drop down list control, the new URL should open up when button is clicked. Basically, when a user selects an entry in drop down list control and click the button, the URL corresponding to that selected entry should open up in new tab.
I have the drop-down list auto-populated and working fine. I need to know how to open up corresponding URL based upon selection from drop down list.

Any idea on how to accomplish this

Thanks Snehal H.Rana SharePoint Consultant


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

Powershell 5.0 JSON to CSV?

Hi

following gives me a nice JSON which is transfromed to CSVs

It works, just wondering if there is a smarter way to do this?

I'm happy that PS 5.0 can handle bigger JSONs without having to go back to

# $rawtext = Invoke-WebRequest -Uri $url
# [void][System.Reflection.Assembly]::LoadWithPartialName("System.Web.Extensions")        
# $jsonserial= New-Object -TypeName System.Web.Script.Serialization.JavaScriptSerializer
# $jsonserial.MaxJsonLength = [int]::MaxValue
# $json2 = $jsonserial.DeserializeObject($rawtext)

$url = "https://data.england.nhs.uk/api/action/current_package_list_with_resources?limit=10" 
$json = Invoke-RestMethod -Uri $url

$extractiondate = "20150618"
$path_results = ".\DataNhse_results_$extractiondate.csv"
$path_resources = ".\DataNhse_resources_$extractiondate.csv"


# Dataset details: Level 1
$i=0
$level1_results = foreach($row in $json.result )`
  {
    #Loop through input.
        $PHEC_result_ID = ($i+1) -join ","
        $result_name = ($row | %{"$($_.name)"}) -join ","

    #Build your flat custom object
    [pscustomobject]@{
            PHEC_result_ID = $PHEC_result_ID
            result_name = $result_name
    }
        $i++
  }

$level1_results | Select-Object $Output | Export-Csv -NoTypeInformation -Path $path_results

# Dataset details: Level 2:  resources
$i=0
$j=0
$level2_results = foreach($row in $json.result )`
  {
    #Loop through input.
        $PHEC_result_ID = ($i+1) -join ","
           
         foreach($row2 in $json.result[$i].resources )`
           {
             #Loop through
                $PHEC_result_resources_ID = ($j+1) -join ","
                $result_resources_description = ($row2 | %{"$($_.description)"}) -join ","
                $result_resources_url = ($row2 | %{"$($_.url)"}) -join ","

        #Build your flat custom object
        [pscustomobject]@{
                    PHEC_result_ID = $PHEC_result_ID
            PHEC_result_resources_ID = $PHEC_result_resources_ID
                    result_resources_description = ($result_resources_description -replace "`r`n", "`\r`\n") -replace "`n", "`\n"
                    result_resources_url = $result_resources_url
          }
               $j++
        }
        $i++
  }

$level2_results | Select-Object $Output | Export-Csv -NoTypeInformation -Path $path_resources


  • Edited by PHEC Sunday, June 21, 2015 6:38 AM
  • Changed type Bill_Stewart Friday, August 14, 2015 6:12 PM

WHY AM I PROMPTED FOR A Permissions error when installing AD LDS with Network Service account - HELP!!!!!

After installing Windows Server 2012 R2 with updates and logging in with the administrator account.

The AD LDS role was installed with all features via the Windows Add roles and features Server Manager snap-in.

Once completed we created the LDS instance with default ports, and default installation paths selected. The Network Service account was selected and the default local administrator account was used under LDS. The MS-User.ldf was imported.

For some strange reason the install wizard then asks for a user name and password for the NETWORK SERVICE account.  This is strange as the Network Service should not prompt for a password.

LDS Error event logs include 1161, 2886, 1463, 614

Warning  614 instance1 (700). Database 'C:\Program Files\Microsoft ADAM\instance1\data\adamntds.dit'; The secondary index 'INDEX_0002000D' of table 'database' may be corrupt. If there is no later event showing the index being rebuilt, then please defragment the database to rebuild the index. 

 

Warning 1463 - Active Directory Lightweight Directory Service has detected and deleted some possibly corrupted indices as part of the initialization.

Can you please assist? This is a new (vanilla) server build with nothing else installed.

This OS build is working on our other systems and we can deploy LDS without problem using the above documented process.

Robocopy /MT forcing /E even when you specify /S

Hi all. I'm using Robocopy in Win7 SP1. I'm migrating some PST files from one server to another. I do not want to create empty folders. It works perfectly via this command:

 

robocopy w:\ v:\ "*.pst*" /b /s /copyall /r:5 /w:10 /v /log:e:\robolog.txt

 

It behaves as it's supposed to by copying only the .pst files and not creating any empty folders where there are no PSTs. For example, let's say I have the following folder structure:

 

W:\ (root)

W:\folder1 <- has a PST file

w:\folder2 <- does NOT have a PST file

 

When issuing the command above, my destination ends up with Folder1 with the PST file and NOT Folder2, which had no pst files. Now, to speed things up, I'll throw in /MT:12 to run 12 threads:

 

robocopy w:\ v:\ "*.pst*" /mt:12 /b /s /copyall /r:5 /w:10 /v /log:e:\robolog.txt

 

It performs the file copies, but it creates all empty folders on the destination as if I had specified the /E switch instead of the /S switch. I am able to reproduce this on several machines and cannot figure out what's wrong. It's as if /MT forces /E. Is this by design or is there a way to get around this? Thanks!

  • Edited by kystin Thursday, October 6, 2011 5:16 PM
  • Changed type Niki Han Tuesday, October 18, 2011 2:48 AM

Reply:

Hi,

 

I have tested the situation you mentioned, it seems this is by design to force robocopy /E when using robocopy /MT, I have the same result with you.

 

I will forward this information to the appropriate department through our internal channel. Both the Microsoft Product Team and Development Team will take into consideration all suggestions and feedback for future releases.

 

Best Regards,

Niki

 

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:
Ah, okay. Thanks, Niki!

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

I've just tried this, and it works correctly for me.

I created a folder on my desktop, and then created 2 sub-folders within that folder. In each of these folders, I created a new text document and then edited each document to contain some random text. I then renamed one of these documents, giving it the suffix .pst instead of the normal .txt to simulate the file conditions you have (i.e. 2 folders, one containing a file of type .pst and one containing a file of another type).

In an elevated command prompt, I then entered the following:

robocopy "c:\users\<UserName>\desktop\test" "c:\users\<UserName>\desktop\test1" "*.pst" /b /s /copyall /r:5 /w:10 /v /log:c:\users\<UserName>\desktop\rc1.txt

and

robocopy "c:\users\<UserName>\desktop\test" "c:\users\<UserName>\desktop\test2" "*.pst" /mt:12 /b /s /copyall /r:5 /w:10 /v /log:c:\users\<UserName>\desktop\rc2.txt

In both cases, the command executed correctly and again in both cases only the folder (and file within) containing the file with the specified extension, .pst, was copied. The other folder was not copied at all.

Now, to simulate copying the data to a separate machine, I shall substitute my external drive as the destination, everything else remaining the same:

robocopy "c:\users\<UserName>\desktop\test" "j:\test1" "*.pst" /b /s /copyall /r:5 /w:10 /v /log:c:\users\<UserName>\desktop\rc3.txt

and

robocopy "c:\users\<UserName>\desktop\test" "j:\test2" "*.pst" /mt:12 /b /s /copyall /r:5 /w:10 /v /log:c:\users\<UserName>\desktop\rc4.txt

Again, in both cases, only the folder (and file within) containing the file with the specified extension, .pst, was copied. The other folder was not copied at all.

I then added a 3rd sub-folder to my source test folder. This time, I deliberately left it as an empty folder. I then repeated all of the above commands. Again, in all cases, only the folder (and file within) containing the file with the specified extension, .pst, was copied. The other folders were not copied at all.


  • Edited by Dwarf63 Thursday, October 13, 2011 1:09 PM

------------------------------------
Reply:
Thanks for your reply! Which version of robocopy were you using to test? I have tried the copy bundled in Win7 and Server 2008 R2 and they're both behaving like my original post. Thanks!

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

Hi,

Do you have some informations from Microsoft's teams?

Best Regards


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

Any progress on this issue? I'm still seeing the problem on Win 7 SP1, Robocopy.exe version 5.1.10.1027.

If you use the /maxage switch along with /mt, then /s doesn't work. You get a copy of every folder in the destination, even if it only contains old files, as if you had used the /e switch.


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

Thank you for highlighting this - had me stumped as to why /S was doing /E!

I suspect its by design because the threads overlap and although one thread may not have anything for the folder, another thread might so it creates it just in case.  I also notice that the /MT option stops the logging showing on-screen so it appears to freeze.  Given these points, I am just going to ditch /MT !

Probably not the response you were hoping for but thank you at least.


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

Need help relating data without relationship (many 2 many)

I have the following data in two tables. I'd like to populate ColumnApps in Table1 with all the apps from Table2.  However the technique needs to be able to pickup a multi valued cell.  If there's no solution with a multi value cell how can I split the data out to get what I need?

Table1:

ColumnServer ColumnApps
------------ ---------------
ServerA Need to populate this, can be multi value
ServerB
ServerC

Table2:

ColumnApp ColumnServers
--------------- -------------------
App1 ServerB,ServerC
App2 ServerA,ServerB
App3 ServerA,ServerC



Reply:
Declare @column varchar(100) = 'SERVERB,SERVERC,SERVERA'   Select @column YourColumn,   PARSENAME(REPLACE(@column,',','.'),3)'Second',   PARSENAME(REPLACE(@column,',','.'),2)'Third',   PARSENAME(REPLACE(@column,',','.'),1)'Fourth'

OR 

select * from Table1 cross apply Table2

Thanks

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

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


  • Edited by SequelMate Friday, March 27, 2015 2:35 PM

------------------------------------
Reply:
Declare @column varchar(100) = 'SERVERB,SERVERC,SERVERA'   Select @column YourColumn,   PARSENAME(REPLACE(@column,',','.'),3)'Second',   PARSENAME(REPLACE(@column,',','.'),2)'Third',   PARSENAME(REPLACE(@column,',','.'),1)'Fourth'

OR 

select * from Table1 cross apply Table2

Thanks

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

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


I should have mentioned that table1 is in powerpivot within excel.  The data is initially pulled from sql.  However table2 is data from an excel spreadsheet.

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

Jon, have you made any progress on this?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


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

Jon, have you made any progress on this?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

Yes, I decided to go a different route.

I created a new table and view to accomplish the task.  I also stopped using Power BI and used native SQL connect functionality in Excel to the data could be copied and manipulated by other users as needed.

Thanks!


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

RPC proxy 401 error, outlook keeps asking for credentials

Hello, I am trying to enable outlook anywhere but when a client connects to the server it keeps asking for credentials.

I am using Exchange 2010 and Windows server 2008 R2.

I used https://testconnectivity.microsoft.com and the connection fails:

An unexpected network-level exception was encountered. Exception details:
Message: The remote server returned an error: (401) Unauthorized.
Type: Microsoft.Exchange.Tools.ExRca.Extensions.MapiTransportException
Stack trace:
at Microsoft.Exchange.Tools.ExRca.Extensions.MapiRpcTestClient.PingProtocolProxy(String endpointIdentifier)
at Microsoft.Exchange.Tools.ExRca.Tests.MapiPingProxyTest.PerformTestReally()
Exception details:
Message: The remote server returned an error: (401) Unauthorized.
Type: System.Net.WebException
Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at RpcPingLib.RpcPing.PingProxy(String internalServerFqdn, String endpoint)
at Microsoft.Exchange.Tools.ExRca.Extensions.MapiRpcTestClient.PingProtocolProxy(String endpointIdentifier)

Elapsed Time: 120 ms.

How can i solve this problem?

sorry for my bad English.



Reply:

Hi

What authentication do you have set for outlook anywhere? is it basic and NTLM? If you run the following command what authentication do you see:

get-outlookanywhere -server <servername> | fl

Hope this helps. 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 used basic authentication.

------------------------------------
Reply:
and in IIS?

Hope this helps. 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:
In iis I have enabled for the rpc directory: windows and basic authentication. 

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

Intune iOS Wipe

Hi All,

We are busy implementing a standalone Microsoft Intune solution for a major client.

What I have experienced.

I have set the number of failed repeated sign-ins to 5, after the 4th and 5th the device automatically is wiped.

My questions is, is there a warning, popup or notification that I can configure to inform the user that the IOS device will be wiped if another login attempt has failed?

Thanks in advance


Reply:

Hi,

Now sorry, I believe that it is an iOS limitation and not possible to display a warning in that scenario.

Regards,
Jörgen

-- My System Center blog ccmexec.com -- Twitter @ccmexec


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

To prevent accidental wipe you could configure more than 6 unsuccessful attempts for iOS devices.

If user enters the wrong passcode into an iOS device six times in a row, he'll be locked out. He will also see a message that says your device is disabled, try again in X minute(s).  After the sixth incorrect passcode users iPhone will be disabled for one minute. For example after 9 failed passcode attempts iPhone will be disabled for 60 minutes (total waiting time will be 81 minutes).

So I think (in  most cases)  in this lockout period user will contact IT group to initiate passcode reset.

Примечание:Сообщения предоставляются "КАК ЕСТЬ" без каких-либо гарантий,выраженных или подразумеваемых | Note: Posts are provided "AS IS" without warranty of any kind, either expressed or implied


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

User Profile Properties Set To Blank If An Item Is Not Found Anymore

I have developed a BCS and it is using SQL Server database to get some additional data in order to extend the User Profiles. The problem I have is that sometimes the secure store fails and no item is returned from the BCS and the Properties which used to have some values before the User Profile Sync are now set to blank. Is this an expected behavior?

Can this be changed/handled somehow?


Migrate Local users from Win server 2003 to Win Server 2012 Data centre

Hi,

Need to migrate Local users from Win Server 2003 to Win Server 2012 Data centre.

During my research got procedure to migrate from 2003 to 2008, is procedure available to migrate from 2003 to 2012 ?

----Tanu---


Reply:

Hello,

please see following article about this https://blog.workinghardinit.work/2013/05/15/installing-using-the-windows-server-migration-tools-to-migrate-local-users-groups/

Best regards

Meinolf Weber

MVP, MCP, MCTS

Microsoft MVP - Directory Services

My Blog: http://blogs.msmvps.com/MWeber

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

Twitter:  


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

People Picker list old and new user last name

After changing last name of some users, and acording to company rules, user name and email address, people picker list both data: old one, lets say Barbara Smith and new one, let say Barbara Wilis;

I try to find where people picker gets old data, but was not successfull. I looked on all three places: UPS, AD, UserInfo; And couldn't find it. I found record in dbo.userinfo, but this record have new username and only lastname is old one.

Any help is appreciated.


  • Edited by Dojcinovic Thursday, June 18, 2015 9:34 AM

Reply:

hi,

from my understanding you have changed a property of user profile in active directory but it doesn't replicated in SharePoint sites.

this may happen if the user profile sync service is not properly executed in environment.

for reference regarding user profile sync please go through the following link

https://technet.microsoft.com/en-us/library/ff681014.aspx#acctName

I search for the similar kind of issue and I got some examples this may help you

http://sharepointdiva.com/2012/09/12/user-profile-properties-not-updating/

Regards

Anandakrishnan M


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

You didn't understand it.

User profile is ok. only place where old data is visible is people picker.


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

Create a expression for sum of distinct values?

Hi all,

I have data in the below format 

Service Numbers    start datetime     enddate time        part number     Calc(in hrs (endate - startdate) 
223344                  2014-05-05          2014-05-07       12345               48
223344                  2014-05-05          2014-05-07       56789               48
223355                  2014-05-06          2014-05-07       17865               24
223355                  2014-05-06          2014-05-07       76543               24
345627                  2014-05-09         2014-05-013      76543               72

I want measure like  sum of  hours of distinct service numbers.I want to use it in a reporting tool

it means my sum will be 144
and my Average of per time closed will be 144/3 =  48

How to write an expression to achieve this as a measure ?

Thanks 

regards 
msbilearning

ADFS service communication certifcate renewal issue in ADFS 3.0

We have 2 ADFS servers in farm with SQL backend & 2 ADFS proxy servers, For service communication we are using Digicert certifcate & Token certiifcates are self signed

Currently we were having SHA1 digicert certificate, we planned to replace sha1 certificates with sha2 certificates & we renewed certificates as well in both ADFS & ADFS proxy servers

Post renewal ADFS relying party application like CRM, sharepoint etc sites are working  from internal entwork but when we try to access from external network we were getting "server hangup" error while accessing the CRM, sharepoint webistes

There was no ADFS related errors was found only below "Schannel" errors was found in only ADFS proxy servers after certiifcate renewal , Does anyone got same error in their environment

Note: we found these events only after certiifcate renewal, after rolling the back the certiifcates to old one these errors gone in the server

Log Name: System

Source : Schannel

Event ID: 36888

Time : 6/15/2015 10.01 AM

Level : Error

User : System

Computer : abc

Description:  A fatal alert was generated and sent to remote endpoint. This may result in termination of connection. The TLS protocol defined fatal error code is 40. The windows Schannel error state is 1205

==============

Log Name: System

Source : Schannel

Event ID: 36874

Time : 6/15/2015 10.01 AM

Level : Error

User : System

Computer : abc

Description:  An TLS 1.2 connection request was received from a remote client application, but none of the cipher suites supported by the client application are supported by the server. The SSL connection request has failed

  • Changed type Frank Shen5 Wednesday, July 8, 2015 1:41 AM Redirected

Reply:

Hi Sunil

Based on the description, in order to get better help, it's recommended that we ask for suggestions in the following forum.

Claim based access platform (CBA), code-named Geneve

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

Best regards,
Frank Shen

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 Subscriber Support, contact tnmff@microsoft.com.


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

I can't think of one now but all is well rightnow!

I just can't think of one right now but if I do have a question I will direct it to you.

Thanks, Ilene Diamond

  • Changed type Yan Li_ Thursday, June 18, 2015 7:10 AM

Reply:
I just need a way to get into this site.

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

Hi,

Thanks for your posting!

I will change this thread to General discussion type as this is not a question.

If you have any question when you use your Windows Operationg System, please feel free to post in this forum, we'd be glad to work out it with you.

Regards,

Yan Li

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 Subscriber Support, contact tnmff@microsoft.com.


  • Edited by Yan Li_ Thursday, June 18, 2015 7:10 AM edit

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

Error when Adding the ID Tag in declaration of UPdatePanel

Hi,

As Soon as i add the Tag ID in the definition of an ID panel, i have this error : System.Web.UI.Updatepanel type not definied.

ie:

<asp:UpdatePanel ID="Up_Panel1" runat="server" UpdateMode="Conditional" ChildrenAsTriggers="False">
        <ContentTemplate><./ContentTemplate> 

</asp:UpdatePanel>

The version Of visual Studio is 2013 up 4 and Sharepoint 2013.

can Anyone help me??? 


Reply:

Hi,

If you want to use AJAX Update Panel in SharePoint, please refer to the link below:

https://msdn.microsoft.com/en-us/library/ff650218.aspx

If you want to create Asynchronous WebPart and use update panel, please check the blog with code and steps below:

http://www.sharepointpals.com/post/Asynchronous-WebPart-in-SharePoint-2013

Best Regards,

Dennis

TechNet Community Support
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.


  • Edited by Dennis Guo Tuesday, June 23, 2015 1:12 AM

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

Windows IT Pro Insider Update Series: Managing reboots required by updates

Operating System updates sometimes require reboots, and no one likes reboots. Reboots can be range from annoying for casual users to business-impacting for mission-critical business workloads. In spite of improvements to reduce their frequency, reboots will continue to be required for the foreseeable future. Please vote and comment if you want this topic covered in the Windows IT Pro Insider.

Reply:
Definitely. Interested in how this changes with Windows 10 and the new Windows Update for Business.

Best regards, Kjetil :) Please remember to click "Mark as Answer" on the post that helps you. This can be beneficial to other community members reading the thread.


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

Hi TH-,

Installing the serurity update will prompt to restart the machine. It is is reasonable.

The updates may update a DLL, .exe file, a device driver, registry entries that are read only when you start your computer. They couldn`t be updated if they are running.

Here is a link for reference, we can take the suggestions included in the link to reduce the chances to restart the machine.
Why you may be prompted to restart your computer after you install a security update on a Windows-based computer
https://support.microsoft.com/en-us/kb/887012

Best 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.


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

IIS Redirecting Incorrectly!

Hello! I seem to be having redirect issues or something when I click links on my website on the same 3 links 'Home', 'Forum' and 'Blog'.. I have attached a screenshot of what it does and as you can see in the web address bar, it seems to duplicate my domain web address. The only thing I have set up for redirects is the Canonical Domain in URL Rewrite and no other redirect options enabled. Any ideas on what the problem is? 
  • Changed type Vivian_Wang Thursday, June 18, 2015 7:23 AM

Reply:

They'll help you over here.

http://forums.iis.net/

 

 

 

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.


------------------------------------
Reply:
Check your hyperlink, surely a typo or a bad entry in it.

Regards, Philippe

Don't forget to mark as answer or vote as helpful to help identify good information. ( linkedin endorsement never hurt too :o) )

Answer an interesting question ? Create a wiki article about it!


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

Web Application Proxy (ADFS Proxy) Intranet / Extranet detection for SSO (and save password checkbox)

Hi!

I have the following network config: INTERNAL <-> DMZ <-> INTERNET

I have my DC and my ADFS 3.0 Server in the INTERNAL zone. I have my WAP (ADFS Proxy) in the DMZ zone.
my ADFS server has a public fqdn. I have on the WAP server a hostfile with the public fqdn pointing to the ADFS server and servers to be published.

On my firewall I have configured a port forwarding rule for https to the WAP server for all required fqdn's.

No matter from which zone I access the WAP published applications I always get to logon via FBA entering username/password. Single Signon by putting the required fqdns in the intranet zone in Internet Explorer also does not work.

I narrowed it down to that I'm Always considered a Extranet user (I can confirm this because when I deselect all checkboxes for Intranet authentication methods in the Global Authentication Policy I still get the forms authentication and when I switch authentication mode from Form to Certificate on Extranet I have to login via Certificate).

How can I make sure that when I am a internal user i get SSO? Any help is greatly appreciated since I'm in a SharePoint migration.

Another question: is the 'Stay Logged in' checkbox which is present on the Microsoft Office365 federation services available in ADFS 3.0? And if so how do I enable it?

  • Changed type Vivian_Wang Friday, June 19, 2015 2:10 AM

Reply:

Hi

For the ADFS related issue, you could ask in:

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

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


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

SharePoint 2010 Search Property "write"

I was looking for info on SearchProperty "write" which acts like a ModifiedDate, I am little confused how it works actually,  I googled but didnt find much info.

So if you can help with this,

Is it a crawled property or managed...?

If its a crawled then how it works behind the scene ie how we are able to use it to filter data based on this property while doing a search query. Also can we create  other crawled properties to have same behaviour

Also why doesnt it show up in Search Administration > Managed Properties section

Any other insight would be great. Thanks!!


Reply:

It is a managed property.

You can find it under the FAST Query Search Service Application --> FAST Search Administration page --> Managed Properties.

You will see the below text on top of the page:

"Crawled properties are automatically extracted from crawled content. Users can perform queries over managed properties. Use this page to create and modify managed properties and map crawled properties to managed properties. Changes to properties will take effect after documents are reprocessed or after the next full crawl. "

When you search for "Write" you will find all the crawled properties that are automatically mapped to this Managed Property. My understanding is that this is a built-in SharePoint FAST Managed Property that has the "lastmodifiedtime".

https://msdn.microsoft.com/en-us/library/office/ff464344(v=office.14).aspx - Here the Write property is mentioned.

You can created your own managed property and map it to the same to crawled properties or different ones as you like. It may have the same behavior as to the date, but I think in the Core Results WebPart, the hours and minutes are removed when you display "Write" property.

Here is a link to Crawled Properties - https://technet.microsoft.com/en-us/library/hh134087.aspx

Hope this gets you started on understanding the Write Property.

CJ01


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

Thanks CJ for the detailed info.

But This property works in Enterprise search service Application as well but not visible under Managed Properties section as it is visible under FAST Search Administration 

Any idea why it is hidden in Enterprise Search

Also any thought if for a crawled property we change the value of 'Included in Index' from Yes to No, and do a full crawl, will that reduce the index size.

 
  • Edited by Ankit G Wednesday, June 17, 2015 3:08 PM

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

My understanding with regard to the Write property is that it is a FAST Managed Property. And I am guessing you have FAST Search Server 2010 installed and using Enterprise Search Center Page when you say "This property works in Enterprise Search Service Application". When you look at CA-->Configure Service Applications Associations do you see the "FAST SSA" in the Application proxies for your Web APP or just your Enterprise Search Service App alone? I am assuming you are seeing the inbuilt FAST property values on the enterprise search center.

Also you will notice "LastModifiedTime" under Enterprise Search Metadata properties mapped to the same SharePoint crawled properties as Write (ows_modified).

People Search does not go through FS4SP but instead uses the built-in SharePoint Search. All queries other than People Search are sent to FAST Search if it is installed. The Metadata properties under Queries and Results are all related to People Search. This is why you see the SharePoint Search, FAST Query Search Service Applications and FAST Content Search Service Applications.

As for your question on removing a Crawled property from being "Included in the Index" - This will remove the property from the search index. I am not sure if that will reduce the index size. This is a good article on estimating capacity requirements - https://technet.microsoft.com/en-us/library/gg750251(v=office.14).aspx

CJ01


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

How to convert a procedure into CTE which has temp tables

Hi All,

Below is my stored procedure.It has a couple of temp tables in it and my requirement is to change this one into a CTE. I am unable to create one for this as it has 2 temp tables and also a cursor. Can someone please help me with this?

ALTER PROC [dbo].[sp_GetInvitationStatusTest]  (	  	@invited_by NVARCHAR (50)--,@City Varchar(40)   )      /*   TEST:      exec [dbo].[sp_GetInvitationStatusTest] 'marakani'      exec [dbo].[sp_GetInvitationStatusTest] 'mortimer'       */  AS    BEGIN    		Declare @City Varchar(40)  		SET NOCOUNT ON  		  		 SELECT T.C.value('.', 'NVARCHAR(100)') AS [City]   INTO #tblPersons   FROM (SELECT CAST ('<Name>' + REPLACE(@invited_by, ',', '</Name><Name>') + '</Name>' AS XML) AS [Names]) AS A   CROSS APPLY Names.nodes('/Name') as T(C)  		   		  		IF OBJECT_ID('#Temp_Final_results','U') IS NOT NULL  			DROP TABLE #Temp_Final_results  		  		CREATE TABLE #Temp_Final_results(Isid VARCHAR(100),[STATUS] VARCHAR(100) ,DATE_INVITED DATETIME, DATE_VISITED DATETIME )  	  		  			DECLARE @ISID VARCHAR(100)  			DECLARE C_ISID CURSOR FOR SELECT DISTINCT invited_isid FROM [merck_acronyms].[dbo].[Merck_Acronym_Invitations]  					WHERE   					--EXISTS( Select City From #tblPersons tmp where tmp.City = Merck_Acronym_Invitations.invited_isid)  					invited_by=@invited_by   					and invited_isid<>@invited_by  			OPEN C_ISID  			FETCH NEXT FROM C_ISID INTO @ISID  			WHILE @@FETCH_STATUS=0  			BEGIN  				IF OBJECT_ID('tempdb..#Temp_user_Details','U') IS NOT NULL  				DROP TABLE #Temp_user_Details  		  			CREATE TABLE #Temp_user_Details(invited_isid VARCHAR(100),status_ID INT , Created_Date DATETIME )  			  			  			INSERT INTO #Temp_user_Details (invited_isid ,status_ID , Created_Date )  			SELECT invited_isid, CASE WHEN invitation_status='Invited' THEN 1  									 WHEN invitation_status='Re-Invited' THEN 2  									 WHEN invitation_status='Visited' THEN 3  									 END as status_ID, Created_Date  				  			FROM   			(  			  			SELECT invited_isid,invitation_status, MAX(invited_on) as Created_Date   			FROM dbo.Merck_Acronym_Invitations  			WHERE invited_isid=@ISID  			GROUP BY invited_isid,invitation_status   			UNION ALL  			SELECT Created_By,'Visited' as invitation_status, MAX(Created_On) Created_On   			FROM dbo.Audit_table  			where New_Values like '%User logged%'  			AND Created_By=@ISID  			GROUP BY Created_By  			) a  			  			--SELECT * FROM #Temp  			DECLARE @Status_ID INT, @Date_Invited DATETIME, @DATE_Visited DATETIME  			  			SELECT @Status_ID=MAX(Status_ID) FROM #Temp_user_Details  			Where invited_isid=@ISID  			  			SELECT @Date_Invited=MAX(Created_Date) FROM #Temp_user_Details  			Where invited_isid=@ISID and status_ID IN (1,2)  			   			SELECT @DATE_Visited=MAX(Created_Date) FROM #Temp_user_Details  			Where invited_isid=@ISID and status_ID IN (3)  			  			INSERT INTO #Temp_Final_results(ISID,[STATUS],DATE_INVITED,DATE_VISITED)  			SELECT @ISID as ISID, CASE @Status_ID WHEN 1 THEN 'Invited'  													 WHEN 2 THEN 'Re-Invited'  														WHEN 3 THEN 'Visited'   									 END as [STATUS], @Date_Invited DATE_INVITED,@DATE_Visited DATE_VISITED   			FETCH NEXT FROM C_ISID INTO @ISID  		END  		CLOSE C_ISID  		DEALLOCATE C_ISID 											   		  		  		SELECT * FROM #Temp_Final_results    		  END

Please let me know if you have any questions or if i am still unclear.

Thanks

  • Changed type pituachMVP Wednesday, June 17, 2015 4:46 PM
  • Changed type Tom Phillips Wednesday, June 17, 2015 4:57 PM
  • Changed type Tom Phillips Wednesday, June 17, 2015 4:58 PM

Reply:
Do you want to remove a cursor? Why do want to replace, performance issue?

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence


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

If you want people to write code for you, it certainly helps if you include

1) CREATE TABLE statements for your table(s)
2) INSERT statements with sample data.
3) The desired result given the sample.
4) A short description of the business rules.
5) Which version of SQL Server you are using.

Yes, there is code we can look at, but that only barely addresses point 4 - an explanation in English helps. And we need the test data anyway. If you want a tested solution, that is.

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

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

Is this still an issue SqlDev12 ?

if yes then pls post the information Erland asked you

signature   Ronen Ariely
 [Personal Site]    [Blog]    [Facebook]


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

As Erland recommended, please provide us necessary things to work upon. 

However, from first glance I can see that this can be done via joining condition.. Prepare, Temp user details without invited_isid and keep IN clause instead. <Hint> ;) 

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:

Hi All,

This is no more an issue as we have to get rid of the whole procedure.Once again thanks to everyone for your help.

Thanks


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

Good day SqlDev12,

Since this is not longer an issue, and we want to close the thread, and it is look like there is not response that answer the question, then I will change the thread to discussion type.

have a nice day,

* please Net time remember to follow threads that you open and close them at the end.

signature   Ronen Ariely
 [Personal Site]    [Blog]    [Facebook]


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

Troubleshooting application deployment issues - Tips

Hello everyone,

Over the course of the last couple of months we have been able to identify some typical problems that you might see when you deploy applications. If you experience any of the following problems, check these recommended troubleshooting steps and information.

 

Problem 1 – application download failures:

  • Client stuck downloading an application
  • Client failed to download application
  • Client stuck at 0% while downloading software

 

Possible solutions and troubleshooting information:

  1. Missing or misconfigured boundaries and boundary groups: If the client is on the intranet and is not configured for Internet-only client management, the client's network location must be in a configured boundary and there must be a boundary group assigned to this boundary for the client to be able to download content. For more information about boundaries and boundary group, see the following TechNet information. Planning for Boundaries and Boundary Groups: http://technet.microsoft.com/en-us/library/gg712679.aspx. Configuring Boundaries and Boundary Groups: http://technet.microsoft.com/en-us/library/hh427326.aspx 
  2. Content might not be distributed to the distribution points yet, which is why it is not available for clients to download. Use the in-console monitoring facilities to monitor content distribution to the distribution points. For more information about monitoring content, see the following blog post: http://blogs.technet.com/b/inside_osd/archive/2011/04/06/configuration-manager-2012-content-monitoring-and-validation.aspx

 

Problem 2 - application deployment compliance stuck at 0%

 

Possible solution and troubleshooting information:

  1. When compliance is 0%, check for the following deployment status for the application in the Monitoring workspace, Deployments node:

 





Reply:
Wow hey thanks for this! Good stuff!

------------------------------------
Reply:
Thanks good catch 

------------------------------------
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Setup is Split Across Multiple CDs

Setup is Split Across Multiple CDs Lately I've seen a bunch of people hitting installation errors that have to do with the fact th...