Internet Explorer is not showing website properly
Respected Friends,
Form last 1 week I am facing problem in a specific website. of amazon seller panal in india. this web page is not showing properly. it look like a static page and even no button and animation and graph is working. if I try to upload some document in this website the automatic uploading is not working even page look like a Microsoft office file. NO animation, No Buttons, No Icon, just simple written words are showing. I have also try to open the same page on googe chrome, and Mozilla firefox. these explorer are also showing same defective problem. If I open this webpage in other computer the webpage is working properly. this problem is only with my computer. please help me regarding this problem and guide me how to correct it and tell me why this happen. I can also in invite on Teamviewer to solve this promble threw remote computing.
Please help me
Thank You
Rajesh Gupta, India
- Moved by IoTGirlMicrosoft employee Saturday, December 10, 2016 2:53 AM Not an MSDN question
- Changed type Dave PatrickMVP Saturday, December 10, 2016 1:16 PM
Script: skip server which is not responding
Hi,
I have this server which is making my script (which checks some servers) hang.
The server itself replies to ping, but when I logon to it, it hangs on "welcome".
What parameter would be the best to check for so my script simply skips situations like these?
So that would be specifically this part
if ("server not responding" )
{ send me a mail $server is not responding)
else { continue my script }
Please advise.
J.
Jan Hoedt
- Changed type Bill_Stewart Monday, March 6, 2017 6:05 PM
- Moved by Bill_Stewart Monday, March 6, 2017 6:05 PM Abandoned/unanswerable as asked
Reply:
You can't. You cannot use a script to start an interactive logon.
This is not a scripting issue. You need to fix the server.
\_(ツ)_/
------------------------------------
Reply:
Thanks. I probably expressed myself wrongly.
I know I need to fix the server, I just want my script not to block on it when it is malfunctioning.
So the question is howto detect that it is not answering to queries instead so my script can continue.
The computer IS responding to a ping so test-connection isn't helping here.
Jan Hoedt
------------------------------------
Reply:
What is it that is blocking?
\_(ツ)_/
------------------------------------
Reply:
The trick, of course, is writing code to test for a condition you can't describe in explicit technical detail.
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
It could be a simple "get-service -computername $computername -Name Dhcp" which is not responding within 10 seconds indicating a timeout but howto approach then?
Jan Hoedt
------------------------------------
Reply:
\_(ツ)_/
------------------------------------
Reply:
That would be
Get-CimInstance -ClassName Win32_OperatingSystem -ComputerName $comp
Jan Hoedt
------------------------------------
Reply:
That is what I suspected. WMI can hang a connection and the only fix is to fix WMI on the remote system.
This is a case where the fist thing to do is to use help for the CmdLet to see how to set the timeout. Have you learned how to use PowerHSell help yet,. It is the first thing that those new to PowerShell need to learn.
If you don't know how to use help just type "help help" and all of the details of how to use help will be displayed.
Quick parameter help can always be returned by adding a -? to the end of any command:
Get-Service -Name myservice -?
"help <cmdlet name>" can get the help for any CmdLet.
\_(ツ)_/
------------------------------------
Reply:
Connecting to WMI presumes that WMI behaves in a predictable way.
This is like saying, "How can I ping a server when its network card is broken?" The answer is that you cannot, and you must fix the underlying problem before you can proceed.
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
I did some testing with Get-CimInstance. If WinRM is configured for the client and servers then the problem never arises. It cannot really hang because of how WinRM is designed. If WinRm is not used then WMI on the remote system will timeout except in some circumstances where there is a deadlock between the two systems. In those cases I have used a job to do the query and kill the job if it fails too complete.
\_(ツ)_/
------------------------------------
New HDs on HP Server showing as Disk 0 -- REALLY NEED HELP - HP blames OS
We have an HP ProLiant 580 G5 running Windows 2008 x64 with Hyper-V. The server is a host for 7 Virtual Servers running combination of 2008 and 2003. Currently the server has an embedded P400 controller which came with the server when we purchased it; this controller has the following configurations:
Raid 1 as C drive (OS)
Raid 5 as D drive where virtual servers are located.
I wanted to install additional drives on the servers so I installed a second P400 controller with (4) 300 GB Drives and rebooted the server. During reboot I went to RBSU and created logical drive for the hard drives connected to second P400 controller that I installed, next I saved settings and continued with rebooting the server. After I logged to the server I opened My Computer window and did not see new drives I added for second P400 controllers, I am only able to see C and D partition. I opened Server Manager>Storage> Disk Management and I got a popup screen with the following info:
You must initialize a disk before logical disk management can access it.
Select Disk:
Disk 0 (check box here)
Use the following partition style for the selected disks:
MBR (Master Boot Record) or
GPT (GUID Partition Table)
I did not initialize the new disk yet since I am not sure if I setup the controller correctly or not. It seemed also that the second controller and drives attached to it are now listed as Disk 0 since I see the following new configuration:
Disk 0 – unknown – 838 GB – Not Initialized – Unallocated
Disk 1- Basic – 136 GB NTFS – C: - Healthy (System Boot, Active, Crash Dump, Primary Partition)
Disk 2 – Basic – 546 GB NTFS – Healthy (Page File, Primary Partition)
Before adding the second P400 controller I had the following disks under Server Manager>Storage> Disk Management:
Disk 0 – C Drive - with Status as System Boot, Active, Crash Dump, Primary Partition
Disk 1 – D Drive - with Status as Page File, Primary Partition
In RBSU and under Boot Controller Order menu and I see the following:
Ctrl 1: PCI Embedded HP Smart Array P400 Controller
Ctrl 2: PCI Embedded HP Storage PCI IDE Controller
Ctrl 3: PCI Slot 9 HP Smart Array P400 Controller
I have tried to contact HP several times with no luck on resolving this issue of why the drives for second P400 controllers are showing as Disk 0 and not disk 3 or 4.
The people at HP Support have indicated that this is an issue with Microsoft but I don't think the issue is related to the OS but could be wrong.
Please advice and thanks in advance for your input.
B
Reply:
Hello,
I found your blog...
What did You enable on Your Proliant dl 580 G5 so HyperV could work?
Regards
Freundliche Grüße Günther Neubauer 8480 Mureck ----------------------------------------------- mailto:neubauer@neubauer-net.com http://www.neubauer-net.com Disclaimer: http://www.neubauer-net.com/disclaimer
------------------------------------
COM Server receives unexpectedly the environment variables of the System account although it has been activated by a service running as a domain user
[COM Server receives unexpectedly the environment variables of the System account although it has been activated by a service running as a domain user]
OS: Microsoft Windows Server 2012 R2 DatacenterA local out-of-proc COM server that was activated in the context of a Windows service running under a domain account with local admin rights inherited the security context of the activator, but its environment variables (e.g. APPDATA, TEMP) were not set as expected to the values of the domain account, but to those of the System account! The use case requires that client and server share the same settings for appdata and temp folder. In addition, the COM server is a third-party component.
Is this behavior by design?
Thank you!
- Changed type Amy Wang_ Monday, December 26, 2016 4:33 AM
Reply:
Might ask over here.
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.
------------------------------------
Reply:
Hi Dave,
Thank you for the advice!
------------------------------------
Color coding a list iem which is displayed in a calendar view
In SharePoint 2013 have created a list of items. I would like to see some of these items display in a Calendar view with a different background colors based on a category. I have seen how this can be done if I were creating Calendar events, but I started with list.
How best can I do this? Thank you.
Helpful view for automation engineers
When I get into the office, I want to see what automation failures and warnings have occurred over the last 24 hours. It helps me keep a sanity check on running runbooks. So each morning I get a daily report that I spot check. We execute a humble 4,000 runbooks every 24 hours, while small fry compared to others, scouring through runbook logs is a pain. I have roughly 10 minutes to spot check 24 hours of activities.
The heart of the report comes from this SQL view that was constructed by one of our summer interns. Since we are an industrial I have approval to share this.
I hope this helps and any feedback enhancements you would like to share is welcome.
USE [RunbookMetrics] GO /****** Object: View [dbo].[HistoricalFailureAndWarningInformation] Script Date: 12/8/2016 9:27:54 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[HistoricalFailureAndWarningInformation] AS WITH HistoricalFailuresAndWarnings AS ( SELECT r.[Name] , i.[Status] , i.[TimeEnded] , o.[Name] AS 'Failing Activity' , CASE WHEN oid.[Value] = '' THEN 'N/a' WHEN LEN(oid.[Value]) <= 50 THEN oid.[Value] ELSE LEFT(oid.[Value], 50) + '...' END AS 'Error Message' , i.[UniqueID] AS 'Instance ID' , r.[Path] FROM [Orchestrator].[dbo].[POLICYINSTANCES] i INNER JOIN [Orchestrator].[Microsoft.SystemCenter.Orchestrator].[Runbooks] r ON r.[Id] = i.[PolicyID] INNER JOIN [Orchestrator].[dbo].[OBJECTINSTANCES] oi ON oi.[InstanceID] = i.[UniqueID] INNER JOIN [Orchestrator].[dbo].[OBJECTS] o ON o.[UniqueID] = oi.[ObjectID] INNER JOIN [Orchestrator].[dbo].[OBJECTINSTANCEDATA] oid ON oid.[ObjectInstanceID] = oi.[UniqueID] WHERE ([Status] = 'warning' OR [Status] = 'failed') AND oid.[Key] = 'ErrorSummary.Text' AND oi.[ObjectStatus] = 'Failed' AND i.[TimeEnded] >= DATEADD(d, 0, DATEDIFF(d, 1, GETDATE())) AND i.[TimeEnded] < DATEADD(d, 0, DATEDIFF(d, 0, GETDATE())) ) , NumberFailedActivities AS ( SELECT [Name], [Instance ID], COUNT([Failing Activity]) AS 'Number of Failing Activities' FROM HistoricalFailuresAndWarnings GROUP BY [Name], [Instance ID] ) SELECT DISTINCT h.[Name] , h.[Status] , h.[TimeEnded] , CASE WHEN [Number of Failing Activities] > 1 THEN CAST([Number of Failing Activities] AS NVARCHAR(100)) + ' failing activities' Else h.[Failing Activity] END AS 'Failing Activity' , CASE WHEN [Number of Failing Activities] > 1 THEN 'Click the runbook name for details' Else h.[Error Message] END AS 'Error Message' , h.[Instance ID] , h.[Path] FROM HistoricalFailuresAndWarnings h INNER JOIN NumberFailedActivities n ON h.[Instance ID] = n.[Instance ID] GROUP BY h.[Name] , h.[Status] , h.[TimeEnded] , h.[Failing Activity] , h.[Error Message] , h.[Instance ID] , n.[Number of Failing Activities] , h.[Path] GO
- Edited by Christopher Carver Thursday, December 8, 2016 3:58 PM
Certificate selection and site assignment across untrusted forests
I have a scenario where I will need to use an SCCM instance in one forest to manage clients in a second, untrusted forest, and I need clients in the second forest to use DPs in the first. A Microsoft rep that I had spoken to indicated that this would require the DPs to use HTTPS.
For proof-of-concept, I've stood up test domains, SCCM 2012 running in one of them. Currently, the only MP and DP are in the first forest. Both forests have their own certificate authority. Client certs have been issued following the guide here http://technet.microsoft.com/en-us/library/gg682023. I've imported the root certs for both CAs into SCCM under Site Properties > Client Computer Communication, as well as the Trusted Root Certificate Authorities store of the site server. Clients in the same forest as SCCM work fine. I'm now trying to install the client manually on a computer in the second forest. I'm running CCMSETUP.EXE /UsePKICert, with SMSSITECODE, SMSMP, and CCMCERTISSUERS defined. The client installs, but fails to talk to the management point.
I see the following in ClientIDManagerStartup.log
Certificate Issuer 1 [CN=CA1; DC=DOMAIN1; DC=com]
Certificate Issuer 2 [CN=CA2; DC=DOMAIN2; DC=com]
Based on Certificate Issuer 'CA1' found Certificate [Thumbprint] issued to 'COMPUTER.DOMAIN2.com'
Begin validation of Certificate [Thumbprint] issued to 'COMPUTER.DOMAIN2.com'
Completed validation of Certificate [Thumbprint] issued to 'COMPUTER.DOMAIN2.com'
Completed searching client certificates based on Certificate Issuers
Begin to select client certificate
Begin validation of Certificate [Thumbprint] issued to 'COMPUTER.DOMAIN2.com'
Certificate [Thumbprint] issued to 'COMPUTER.DOMAIN2.com' doesn't have private key or caller doesn't have access to private key.
Completed validation of Certificate [Thumbprint] issued to 'COMPUTER.DOMAIN2.com'
Raising event:
instance of CCM_ServiceHost_CertRetrieval_Status
{
DateTime = "20120523192930.660000+000";
HRESULT = "0x87d00283";
ProcessID = 4740;
ThreadID = 4896;
};
Failed to submit event to the Status Agent. Attempting to create pending event.
Raising pending event:
instance of CCM_ServiceHost_CertRetrieval_Status
{
DateTime = "20120523192930.660000+000";
HRESULT = "0x87d00283";
ProcessID = 4740;
ThreadID = 4896;
};
Unable to find PKI Certificate matching SCCM certificate selection criteria. 0x87d00283
Reply:
Found an issue with the template that was used to issue the certificate. Corrected this, issued a new cert, client selects it correctly. But there still seems to be an issue talking to the MP. Site assignment is failing, and it doesn't look like the client is actually using the cert that it selected. Configuration Manager Properties > General > Client Certificate = None.
LocationServices.log
Assigning to site 'LAB'
LSIsSiteCompatible : Verifying Site Compatibility for <LAB>
Retrieved lookup MP [MP.SCCMLAB.COM] from Registry
Attempting to retrieve lookup MP(s) from AD
No lookup MP(s) from AD LocationServices
Attempting to retrieve lookup MP(s) from DNS
Attempting to retrieve default management points from DNS
Found DNS record of mp.sccmlab.com port 443
Lookup Management Points from DNS:
Name: 'mp.sccmlab.com' HTTPS: 'Y' ForestTrust: 'N'
Retrieved lookup MP(s) from DNS LocationServices
LSGetSiteVersionFromAD : Failed to retrieve version for the site 'LAB' (0x80004005)
Retrieved lookup MP [MP.SCCMLAB.COM] from Registry
Attempting to retrieve lookup MP(s) from AD
No lookup MP(s) from AD
Attempting to retrieve lookup MP(s) from DNS
Attempting to retrieve default management points from DNS
Found DNS record of mp.sccmlab.com port 443
Lookup Management Points from DNS:
Name: 'mp.sccmlab.com' HTTPS: 'Y' ForestTrust: 'N'
Retrieved lookup MP(s) from DNS
Failed to send site information Location Request Message to MP.SCCMLAB.COM
LSIsSiteCompatible : Failed to get Site Version from all directories
Won't send a client assignment fallback status point message because the last assignment error matches this one.
CcmMessaging.log
[CCMHTTP] ERROR: URL=http://MP.SCCMLAB.COM/ccm_system/request, Port=80, Options=480, Code=0, Text=CCM_E_BAD_HTTP_STATUS_CODE
Raising event:
instance of CCM_CcmHttp_Status
{
DateTime = "20120524150618.264000+000";
HostName = "MP.SCCMLAB.COM";
HRESULT = "0x87d0027e";
ProcessID = 3984;
StatusCode = 403;
ThreadID = 3208;
};
Successfully sent security settings refresh message.
Successfully sent location services HTTP failure message.
Post to http://MP.SCCMLAB.COM/ccm_system/request failed with 0x87d00231.
- Edited by JeremySD Thursday, May 24, 2012 3:25 PM
------------------------------------
Reply:
------------------------------------
Reply:
Reinstalled the agent with CCMLOGLEVEL=0.
CertificateMaintenance.log
Using the certificate [Thumbprint] issued to 'computer.domain2.com'.
clientidmanagerstartup.log
>>> Client selected the PKI Certificate [Thumbprint] issued to 'computer.domain2.com'
Raising event:
instance of CCM_ServiceHost_CertRetrieval_Status
{
DateTime = "20120524171640.720000+000";
HRESULT = "0x00000000";
ProcessID = 2384;
ThreadID = 3040;
};
ClientIDManagerStartup 5/24/2012 1:16:40 PM 3040 (0x0BE0)
Failed to submit event to the Status Agent. Attempting to create pending event.
and then
Using the certificate [Thumbprint] issued to 'computer.domain2.com'.
RegTask: Failed to refresh site code. Error: 0x8000ffff
CCMMessaging.log and LocationServices.log look the same. Ccmexec.log offers no clues. I'm not sure what CCMMessaging.log is supposed to be, I don't see it on the list over here http://technet.microsoft.com/en-us/library/hh427342.aspx but it sure seems like the client is at least trying to use the cert. It just doesn't seem to be actually making any HTTPS connection attempts.
Edit: looking in that log on one of the working clients on domain1, the connections do say HTTPS.
Edit Edit: looked at the IIS logs on the site server, seems like every hit from this computer has been port 80.- Edited by JeremySD Thursday, May 24, 2012 6:26 PM
------------------------------------
Reply:
Other factors forced us to establish trusts between our production forests. However, even after creating a two-way trust between my two test forests, this issue remained. To better reflect the new plan for our production environment, I rebuilt both test forests, two-way selective authentication forest trust, SCCM2012 in forest 1, HTTPS only, site information being published to both ADs, and a CA in 1 enabled for cross-forest certificate enrollment. Clients in forest2 are now hitting the MP on HTTPS, and things are looking happy.
Still don't know why it didn't work before. What's interesting is that in LocationServices.log, I still see the following when the client attempts to locate it's MP:
Name: 'LAB1-SCCM.SCCMLAB1.local' HTTPS: 'Y' ForestTrust: 'N'
Does this indicate that the client doesn't recognize the trust?
- Edited by JeremySD Friday, June 1, 2012 4:55 PM
------------------------------------
Reply:
I know this is an old topic, but I struggled with this for months before I figured it out.
I was getting this same error:
Certificate [Thumbprint] issued to 'COMPUTER.DOMAIN2.com' doesn't have private key or caller doesn't have access to private key.
This ended up being an issue with the key storage provider I chose for building the certificate request. It MUST be the legacy key, not the CNG key SP. SCCM cannot (or doesn't try to) read the storage location for CNG keys, it only accesses the legacy key storage location.
------------------------------------
Create cluster with SOFS
I need create a hyper-v cluster on this hardware:
1) Host 1
2) Host 2
3) Fileserver
4) SAN
5) Switch 1 Gb/s
6) Windows server 2012 R2 standard - 3 License
Scale-out File server approach for the files server, but we don't have VMM license.
Without VMM can'not add storage to the Hyper-V cluster.
__________________________________________________________
What is the best approach in my situation?
Reply:
------------------------------------
Reply:
I need create a hyper-v cluster on this hardware:
1) Host 1
2) Host 2
3) Fileserver
4) SAN
5) Switch 1 Gb/s
6) Windows server 2012 R2 standard - 3 License
Scale-out File server approach for the files server, but we don't have VMM license.
Without VMM can'not add storage to the Hyper-V cluster.
__________________________________________________________
What is the best approach in my situation?
You need at least two physically separate hosts to have Scale-Out File Server.
Install Prerequisites for Scale-Out File Server
https://technet.microsoft.com/en-us/library/hh831478(v=ws.11).aspx
In your case it makes sense to SKIP "Scale-out File server" part as it's single point of failure and performance bottleneck and "feed" SAN directly to "Host 1" and "Host 2" (make sure you have redundant switches, your "Switch 1 Gb/s" is also SPOF).
Cheers,
Anton Kolomyeytsev [MVP]
StarWind Software Chief Architect
Profile:Note: Posts are provided "AS IS" without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.
------------------------------------
Reply:
------------------------------------
Reply:
1) Cannot use 2 SOFS because license only 3.
2) Scheme changed. I''ll see that SOFS connect to the SAN directly via SAS.
What sped will be between SOFS and hosts via smb3.0?
------------------------------------
Reply:
"Cannot use 2 SOFS because license only 3"
Not sure what you mean here. You show only three hosts in your diagram - two cluster nodes and a file server.
"I''ll see that SOFS connect to the SAN directly via SAS"
Talk to your SAN vendor to make sure they support it. Not all SAN vendors support SMB 3.0 connectivity. And then, if they do, they might not support some of the 'nuanced' capabilities like SMB 3.02. But I may be misinterpreting what you are calling a SAN. By definition a SAN has its own operating system that provides intelligent storage capabilities. If you say you can connect directly to the 'SAN' via SAS, it sounds more like a storage shelf than a SAN. Need a better explanation of your environment.
"What sped will be between SOFS and hosts via smb3.0?"
It is recommended to have a minimum speed of 1 Gbps, but 10 or more is preferred.
. : | : . : | : . tim
------------------------------------
Reply:
Just in case you need a step-by-step guidance on how to set up and configure Scale-Out File server https://www.starwindsoftware.com/sw-providing-ha-shared-storage-for-scale-out-file-servers
Guide is intended to be used with Starwind, so you can just bypass this part and start from page 13.
- Edited by Taras Shved Tuesday, November 1, 2016 7:31 PM
------------------------------------
Reply:
"Cannot use 2 SOFS because license only 3"
Not sure what you mean here. You show only three hosts in your diagram - two cluster nodes and a file server.
"I''ll see that SOFS connect to the SAN directly via SAS"
Talk to your SAN vendor to make sure they support it. Not all SAN vendors support SMB 3.0 connectivity. And then, if they do, they might not support some of the 'nuanced' capabilities like SMB 3.02. But I may be misinterpreting what you are calling a SAN. By definition a SAN has its own operating system that provides intelligent storage capabilities. If you say you can connect directly to the 'SAN' via SAS, it sounds more like a storage shelf than a SAN. Need a better explanation of your environment.
"What sped will be between SOFS and hosts via smb3.0?"
It is recommended to have a minimum speed of 1 Gbps, but 10 or more is preferred.
. : | : . : | : . tim
We have Dell MD 3220 which have SAS, Ethernet ports and own operation system.
Cable connect SOFS and SAN:
We always create cluster only with SAN connected to host through Optical switch and FC.
Scheme with SOFS it's new for me and i have many questions about it.
------------------------------------
Reply:
Okay, Dell labels the MD series as storage arrays - not SANs. Not a biggie, just a clarification of terminology. A SAN does not need a Windows Server front-ending it in order for accessing the disks. That's one reason Dell purchased EMC - to get into the SAN business.
Here's is a TechNet article on deploying a SOFS - https://technet.microsoft.com/en-us/library/hh831359%28v=ws.11%29.aspx?f=255&MSPPError=-2147217396
. : | : . : | : . tim
------------------------------------
Reply:
------------------------------------
Reply:
Today create cluster:
1) Create with 2 hosts (host1 + host2)
2) add File server to the cluster
3) Add Disks from File server to CSV. File server always will be owner of CSV.
Now i have cluster consist of 3 nodes.
IT's not SOFS, but it work! :)
------------------------------------
rdp and sierra: cannot transfer files using version 8.2.29 build 732
i've upgraded to sierra and i'm running the latest rdp beta. i'm no longer able to transfer files between the two environments.
- Changed type Eva SeydlMicrosoft employee Tuesday, March 28, 2017 3:37 PM
Reply:
Hi,
To my knowledge, the feature "Access to remote resources" hasn't been added in this beta Version 8.2.29, it will be added in the future updates.
https://rink.hockeyapp.net/apps/5e0c144289a51fca2d3bfa39ce7f2b06/
Please try the normal released Version: 8.0.36:
https://itunes.apple.com/us/app/microsoft-remote-desktop/id715768417?mt=12
Best Regards,
Alvin Wang
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
------------------------------------
Reply:
Hi,
Just checking in to see if the information provided was helpful. Please let us know if you would like further assistance.
Best Regards,
Alvin Wang
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
------------------------------------
read committed snapshot isolation question
Guys, i have a ETL that runs every each five minutes and load
approximately 190 thousands lines, this is like monitoring in QlikView.. So, i wanna know how is the best way to dont give any lock for update, insert, select or delete in production.. I just need an idea because i'm monitoring all Brazil with our WMS System.. Anyone here can help me with any idea? Thank u guys..
Rafael Marvila IT Profissional
Reply:
Can you use Partitioning and load your new data to an empty partition and then switch this into your main tables? This can achieve the load with virtually no locking and blocking.
Search for "Sliding Window Partitioning" for more details.
Martin Cairney SQL Server MVP
------------------------------------
Reply:
Hello Martin!
Do you have some article with this example? Sure, i'll search about Sliding.
Rafael Marvila IT Profissional
------------------------------------
Reply:
https://technet.microsoft.com/en-us/library/aa964122(v=sql.90).aspx
https://blogs.msdn.microsoft.com/sqlserverfaq/2012/02/27/table-partitioning-concepts-with-sliding-window-example/
https://www.littlekendra.com/2016/02/02/sliding-window-table-partitioning-what-to-decide-before-you-automate/
Martin Cairney SQL Server MVP
------------------------------------
Reply:
Rafael Marvila IT Profissional
------------------------------------
Reply:
The only options you can set at the database level are whether SNAPSHOT isolation is used. Otherwise it defaults to READ_COMMITTED
This can be overwritten at a transaction level by using the command:
SET TRANSACTION ISOLATION LEVEL <your choice>
This changes the isolation level for that transaction only.
You can check whether SNAPSHOT isolation is in use using:
SELECT name, snapshot_isolation_state_desc FROM sys.databases
Martin Cairney SQL Server MVP
------------------------------------
Help on SMTP error 5.2.1 from Exchange 2010 mailbox user to Exchange 2003 mailbox user in same Domain
I have an Exchange 2003 server that I have been running for many years. I added a new Exchange 2010 server as part of the same Domain. I moved a user from the Exchange 2003 server to the Exchange 2010 server and when emails are sent that include an attachment from the Exchange 2010 user to a user still on the Exchange 2003 server, I get SMTP error 5.2.1 ... The most recent instance included a 112 KB .PDF file.
I did verify an email with only a small amount of text works.
Thanks for any advice on what I can do to resolve this error.
Dean
Reply:
------------------------------------
I need to biz partner/ employee , inside or remotely, as long as I can make money
|
- Moved by IoTGirlMicrosoft employee Wednesday, December 7, 2016 9:46 PM Not a developer question
- Changed type Dave PatrickMVP Wednesday, December 7, 2016 10:14 PM
Reply:
I can be happy if I can work or communicate with a specific person, can you please provide email address of that person?
- Moved by IoTGirlMicrosoft employee Wednesday, December 7, 2016 9:45 PM Not a developer question
- Merged by Dave PatrickMVP Wednesday, December 7, 2016 10:16 PM same issue
------------------------------------
Reply:
Hello Belief Asher,
This forum is for Technical Developer questions (MSDN = Microsft Developer Network). Please follow up through the site where you submitted your application.
Sincerely,
IoTGirl
------------------------------------
Powershell Variable Output Problem
I have a reoccurring problem in many of my scripts. I do a lot of WMI queries where I store the variable and use it later in the script. The problem is that when I try to use these variables, the variable contains values like the following:
PS H:\ Write-Host $Model
@{Model=Latitude E7470}
I just want the value "Latitude E7470". However, I can't figure out why sometimes I just get the value and sometimes I get the entire string. I can use Write-Host or Write-Output and I don't seem to get consistent results.
Any help with this issue would be greatly appreciated!
- Changed type Bill_Stewart Monday, March 6, 2017 6:03 PM
- Moved by Bill_Stewart Monday, March 6, 2017 6:04 PM Abandoned/vague
Reply:
Richard Mueller - MVP Enterprise Mobility (Identity and Access)
- Edited by Richard MuellerMVP Wednesday, December 7, 2016 8:49 PM clarify
------------------------------------
Reply:
It depends on where the variable $Model comes from. Since you brought up WMI, I am guessing that $Model is a WMI ManagementObject:
PS C:\> $os = Get-WmiObject Win32_OperatingSystem PS C:\> $os.GetType().Name ManagementObject
So in this example, we have the $os variable that contains a WMI ManagementObject object that contains properties. We can pipe to Get-Member to see available properties and methods:
PS C:\> $os | Get-Member
So if you want a specific property of an object, just use the "." to get it. For example, to get the SystemDirectory property:
PS C:\> $os.SystemDirectory C:\Windows\system32
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
\_(ツ)_/
------------------------------------
Backup VLANs for Hyper-V host
Hi Techies,
We have got the requirement that create a separate VLAN for all the clients including Hyper-V VMs which is part of failover clusters 2012 R2.
Need your suggestions,how it is achieved in your organization?
We have four NICs.
Two NICs for Management which is teamed up.
One NIC for Live-Migration &
One NIC for Heartbeat
Can i Use LM NIC for backup VLAN? as i heard that LM can be managed management NIC itself.
Please suggest.
Regards,
KR
Reply:
There is no need for a separate 'heartbeat' NIC. In fact, there is no such thing as a 'heartbeat' NIC in clusters. You say you have a NIC team for Management. That is were cluster communication, which includes a heartbeat component, automatically runs.
In your configuration, you have not specified a NIC for use by the VMs. All you have specified are NICs for host functions. Yet you start out by saying that you need a separate VLAN for "all the clients including Hyper-V VMs ". How are you addressing that?
You might be better served by teaming all four of your NICs on the parent partition. The make team NICs for your various needs. One team NIC for management, one team NIC for Live Migration, one or more team NIC for VM access, etc. You can assign different VLANs (if necessary) to each team NIC.
. : | : . : | : . tim
------------------------------------
Reply:
Hi Tim,
Two NICs for Management which is teamed up - Used by VMs as well. Isn't not the right thing to do?
I thought that's how it should be.
So i can use heartbeat network for Backups.
Regards,
KR
------------------------------------
Reply:
You have two options assuming you have a managed physical switch:
- VLAN tagging: Leave your configuration unchanged. Configure the switch port from your VM NIC to a Trunk Port and add the additional VLAN as a allowed VLAN. Then you VLAN tagging in your vmNIC properties to connect the VM's to the correct VLAN.
- Converged Networking with VLAN tagging: As Tim mentions and I agree; you are better of creating one big NIC Team with all four NICs. This will leave you with one Team NIC. Configure a Hyper-V vSwitch called "Management" on top of the Team NIC Team, and share it with the management OS. Then add two additional vNIC's on top of the vSwitch, named 'Live Migration' and one for 'Cluster'. You have to configure VLAN tags for these vNICs. You also need to make sure that the VLAN are configured as allowed on the physical switch trunk ports.
Boudewijn Plomp | Conclusion FIT
Please remember, 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 posting is provided "AS IS" with no warranties, and confers no rights.
------------------------------------
Reply:
"So i can use heartbeat network for Backups"
As stated earlier, there is no such thing as a heartbeat network in clusters. So, yes, what you are incorrectly calling your heartbeat network in your original post can be used for backups.
An advantage to configuring the way Boudewijn and I are advocating is that you can create multiple networks and assign different QoS settings to them. This allows you to dynamically change how networks are used to ensure different performance levels at different times of the day.
. : | : . : | : . tim
------------------------------------
Reply:
Yep, that is your best option we can recommend you. Steps you need to do:
- Make sure that each physical NIC is connected to a trunk port on your switch (with all VLANs you need).
- With the LBFO GUI create a NIC Team (NIC1 + NIC2).
- With the Hyper-V GUI create a vSwitch on Team NIC (label it "Management" and share it with your OS)
- With PowerShell create another vNIC on the vSwitch (label it "Cluster")
- With PowerShell create another vNIC on the vSwitch (label it "Live Migration")
- With PowerShell assign a VLAN tag to the additional vNICs (Cluster and Live Migration) The vNIC with label "Management" should be left untagged.
- With PowerShell configure QoS based on 'weight' like Tim just mentioned. For example; 30 for Management, 20 for Live Migration and 10 for Cluster. Then the remaining 40 is for your VMs.
Now this may not be the best step description, and I prefer to configure everything with PowerShell. I highly recommend you do some research on the internet. There is plenty of documentation on this.
Boudewijn Plomp | Conclusion FIT
Please remember, 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 posting is provided "AS IS" with no warranties, and confers no rights.
------------------------------------
[Solved] How to reintall Windows 10 from a Pre-Installed Laptop without CD
Hello Folks,
A very basic question, I had purchased a laptop with pre-windows 10 installed on it.
I will appreciate if someone may kindly help to guide me that; how could I able to reinstall windows 10 on the same laptop?
is there any recovery partition from where I reinstall it?
I do not have any CD that came with this laptop, and I also do not have any windows 10 licensed key since, since windows 10 was already installed on my purchased laptop.
Please guide!
Thanks & regards
Ali
- Edited by Reyan- Wednesday, December 7, 2016 6:20 PM
Reply:
------------------------------------
Reply:
Thanks Darren,
May be due to some viruses, after login into windows 10, my operating system stop responding and take ages to perform any action.
Is there any other way to install the windows 10 during boot time of windows?
or if I download windows 10 from Microsoft side, and install on the same machine, do I still need to put the Windows license key to activate my windows 10?
Thanks & regards,
Ali
------------------------------------
Reply:
If you get the login screen hold the shift key down and click the power then restart, that will restart into the recovery environment. http://www.tenforums.com/tutorials/5487-recovery-environment-use-troubleshoot-windows-10-failure-boot.html is a guide to that.
Download Windows 10 and the Download tool now link can create a bootable usb to do a clean install. You can do that and 'I do not have a product ... reinstall..' on the key screen. Install the same version Home or Pro and the digital entitlement will activate as the same machine when it is online.
------------------------------------
Reply:
------------------------------------
Windows 10 Drag and Drop not working with MS software
I have a new PC and drag and drop was working... ie: draging an Outlook 2016 to a folder, Visio draging anything, etc., now it doesn't.
How can I get this working again? I saw (Google) pressing the escape key seems to work, but it doesn't for me... and I rebooted several times since the problem started.
Thanks,
Paul
In addition drag and drop does work in the desktop.
Reply:
There should be a fix coming mid-December.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_outlook-mso_win10/unable-to-drag-and-drop-emails-tasks-or/85d75918-4d34-4ca8-9754-2d67775947dd
------------------------------------
Reply:
------------------------------------
Running two programs
- Changed type Bill_Stewart Monday, January 9, 2017 11:01 PM
- Moved by Bill_Stewart Monday, January 9, 2017 11:01 PM This is not "scripts on demand"
Reply:
------------------------------------
Deploy W7 thin with SCCM 2012
Hi all ,
I need your help , I plan to deploy image in our Win7 Thin machine ( about 800 PC's) using Task Sequence in SCCM 2012 using MAC adresses
The problem is that during deployement we need to press F12 to PXE boot in some PC , the bios configuration for boot is not the same in all the machines , it is different from PC to another.
so I tried to use the File-Based Write Filter (FBWF) to send the image by Task sequence but failed because this needs a manual intervention to set the shutdown script, I need your precious help , what is the best solution to my problem , thank you so much
Reply:
Hi,
if I get your Problem right, you try to image your machines via SCCM Task Sequence, but for some machines the boot priority is not set to boot from network, therefore some of the machines are not PXE Booting. Is this correct?
Which vendors do your machines come from? Dell and HP for example deliver Tools to adjust your BIOS settings.
Cheers
------------------------------------
SQL Server: Dynamic load of flat files with heterogeneous column structures without using C#, Visual Basic, or PowerShell
This article discusses how one can dynamically load flat files that are of heterogeneous structure to a SQL Server database without having to use languages like C#, Visual Basic, or PowerShell to handle variations in column definitions. The discussion will be as simple as possible so that even if one is new to SSIS they will be able to follow the steps. I have used SQL 2008R2 for illustration purposes in this discussion.
Prerequisites
- Stack of files to be loaded – this will be in a landing folder.
- Control table with destination tables definitions – this table will have definitions of table names, column names, and data types.
- SSIS variables – create the following SSIS variables
| Variable Name | Scope | Data Type |
| Archive_Folder_Path | My_Package | String |
| Database_Name | My_Package | String |
| File_Name | My_Package | String |
| Landing_Folder_Path | My_Package | String |
| Project_Build_Version | My_Package | String |
| Move_File_To_Archive_Folder | My_Package | String |
| Parent_Folder_Path | My_Package | String |
| SQL_Statement_to_Load_Final_Destination_Table | My_Package | String |
| SQL_Statement_to_Load_Final_Destination_Table_OBJECT | My_Package | System.Object |
| Table_Name | My_Package | String |
Step by step sequence
Step by step sequence follows the steps displayed on the below SSIS package diagram.
FELC Load Files (For Each Loop Container)
- This points to the file source folder. In the case of this example, the following has been used:
- Folder: \\my_server\my_drive\my_folder\sub_folder\Landing_Folder\
- Files: *.txt
SQL Logic Placeholder (Execute SQL Task)
- I only included this to make it possible for me to apply filter action on the precedent constraint so that only relevant files are processed.
- Precedent Constraint Expression: SUBSTRING( @[User::File_Name], 1, 3) == "LLD" || SUBSTRING( @[User::File_Name], 1, 3) == "LLC"
SQL Create Table (Execute SQL Task)
- This task executes a stored procedure which dynamically creates target and staging tables. This can be a one off exercise. It's all up to you depending on the requirements of the business whether there is a need to create tables each time the process is run or not. This procedure is set to create tables anew each time the package is run.
- Please note the order in which the tables are created in the stored procedure. In this example I have set,
- The final destination table to be created first using data from the control table that holds table definitions.
- The staging table is then created using INFROMATION_SCHEMA. All data types in the staging table are of VARCHAR type. Anything other than that might result in "Bulk load conversion error" due to mismatch of data types.
- There are three parameters to be mapped on this task (Execute SQL Task) which will ultimately feed into the stored procedure. These are,
- User::Table_Name
- User::Project_Build_Version
- User::Database_Name
- SQLStatement: exec usp_dynamically_create_target_and_staging_tables ?,?,?
- Find below an example stored procedure that I have used for this article:
Due to a limitation of the document length, I couldn't the first SQL query on this discussion. Please find the query on the same article presented on this link.
SQL Load Staging Table BULK INSERT TEXT FILES (Execute SQL Task)
This task executes a stored procedure to bulk insert data to the staging table.
- SQLStatement: usp_load_staging_table ?,?,?,?
- Parameters:
- User::File_Name
- User::Table_Name
- User::Landing_Folder_Path
- User::Database_Name
Below is the stored procedure:
/* =============================================
-- Author:
-- Create date:
-- Description:
This procedure loads staging tables
-- Revision History:
-- =============================================*/
CREATE PROCEDURE [dbo].[usp_load_staging_table]
@File_Name VARCHAR(255), --= 'My_Test_Name_bulk',
@Table_Name VARCHAR(255), --= 'My_Test_Name',
@Landing_Folder_Path VARCHAR(255), --= '\\my_server\my_drive\my_folder\sub_folder\Landing_Folder\',
@Database_Name VARCHAR(100) --='My_Database'
AS
BEGIN
SET NOCOUNT ON;
--DECLARE @File_Name VARCHAR(255) = 'My_Test_Name_bulk'
--DECLARE @Table_Name VARCHAR(255) = 'My_Test_Name'
--DECLARE @Landing_Folder_Path VARCHAR(255) = '\\my_server\my_drive\my_folder\sub_folder\Landing_Folder\'
--DECLARE @Database_Name VARCHAR(100) ='My_Database'
DECLARE @LoadTempTableSQLStatement NVARCHAR(4000)
SET @LoadTempTableSQLStatement =
'BULK INSERT ' + @Database_Name + '.staging.' + @Table_Name + '
FROM ''' + @Landing_Folder_Path + @File_Name + '.txt''
WITH
(
FIRSTROW = 1 --(start on row 1)
,DATAFILETYPE = ''char''
--,FIELDTERMINATOR = ''"\,"'' --use t if Tab Delimited and , if comma delimited
,FIELDTERMINATOR = ''|'' --use t if Tab Delimited and , if comma delimited
,ROWTERMINATOR = ''\n''
,KEEPNULLS
)'
--print @LoadTempTableSQLStatement
exec sp_executeSQL @LoadTempTableSQLStatement
END
GO
SQL Generate SQL Statement to Load Final Destination Table (Execute SQL Task)
This task executes a stored procedure that generates a SQL script which pulls data from the staging table to the final destination table. One thing to note about this task is the Result Set. Below are the details of the settings within the task:
- ResultSet: Full result set
- SQLStatement: exec usp_dynamically_create_script_to_load_destination_table ?,?,?
- Result Set Variable: User::SQL_Statement_to_Load_Final_Destination_Table_OBJECT
Below is the stored procedure. Please note that this stored procedure will convert data from VARCHAR to the data types defined in the final destination table.
/* =============================================
-- Author:
-- Create date:
-- Description:
This procedure dynamically creates scripts to load data from staging to destination tables
-- Revision History:
-- =============================================*/
CREATE PROCEDURE [dbo].[usp_dynamically_create_script_to_load_destination_table]
@Table_Name VARCHAR(255) --= 'My_Test_Name'
,@Project_Build_Version VARCHAR(50) --= '2.9.0.0'
,@Database_Name VARCHAR(100) --='My_Database'
AS
BEGIN
SET NOCOUNT ON;
--DECLARE @Project_Build_Version VARCHAR(250) = '2.9.0.0'
--DECLARE @Table_Name VARCHAR(255) = 'My_Test_Name'
--DECLARE @Database_Name VARCHAR(100) ='My_Database'
DECLARE @CreateSQLStatement NVARCHAR(4000)
SET @CreateSQLStatement =
'SELECT SQLStatement = ''INSERT INTO ' + @Database_Name + '.something_schema.' + @Table_Name + ' SELECT '' + STUFF(
(SELECT '', '' + CASE
WHEN CONVERT(VARCHAR,CHARACTER_MAXIMUM_LENGTH) IS NOT NULL THEN + '' CONVERT('' + Data_type + ''('' + CONVERT(VARCHAR,CHARACTER_MAXIMUM_LENGTH) + ''),'' + COLUMN_NAME + '') AS '' + COLUMN_NAME
WHEN CONVERT(VARCHAR,CHARACTER_MAXIMUM_LENGTH) IS NULL
AND DATA_TYPE IN (''datetime'',''date'') THEN + '' CONVERT(datetime, '' + COLUMN_NAME + '',101) AS '' + COLUMN_NAME
WHEN CONVERT(VARCHAR,CHARACTER_MAXIMUM_LENGTH) IS NULL
AND DATA_TYPE NOT IN (''datetime'',''date'',''text'')
AND DATA_TYPE NOT LIKE ''%int%'' THEN + '' CONVERT('' + Data_type + '','' + COLUMN_NAME + '') AS '' + COLUMN_NAME
WHEN CONVERT(VARCHAR,CHARACTER_MAXIMUM_LENGTH) IS NULL
AND DATA_TYPE LIKE ''%int%'' THEN + '' CONVERT(bigint,'' + COLUMN_NAME + '') AS '' + COLUMN_NAME
ELSE COLUMN_NAME
END
FROM ' + @Database_Name + '.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ''' + @Table_Name + '''
AND TABLE_SCHEMA = ''something_schema''
ORDER BY ORDINAL_POSITION
FOR XML PATH('''')),1,1,'''') + '' FROM ' + @Database_Name + '.staging.' + @Table_Name + ''''
--print @CreateSQLStatement
exec sp_executeSQL @CreateSQLStatement
END
GO
FELC Load Final Destination Table (For Each Loop Container)
The purpose of this container is to 'dispense' the query that has been dynamically created in the preceding task so that data can be loaded to the final destination. At this point that query is help in a variable of Object data type. The following settings should be applied to the For Each Loop Container:
- Enumerator: Foreach ADO Enumerator
- ADO object source variable: User::SQL_Statement_to_Load_Final_Destination_Table_OBJECT
- Enumerator mode: Rows in the first table
- VARIABLE MAPPINGS: User::SQL_Statement_to_Load_Final_Destination_Table (NB: you need to create this SSIS variable beforehand)
SQL Load Final Destination Table
This task loads the final destination table using the query generated in the "SQL Generate SQL Statement to Load Final Destination Table" Task. This query is executed via SSIS variable User::SQL_Statement_to_Load_Final_Destination_Table. Take note of the following settings:
- SQL_Statement_to_Load_Final_Destination_Table variable expression: None. The variable is loaded with a query that is ready to be excuted.
The remaining two tasks can be easily completed by referring to the relevant section on the book online to get information about how to use them.
See my other article entitled "SSIS Hints & Tips: Handling Flat Files" on http://social.technet.microsoft.com/wiki/contents/articles/23883.ssis-hints-tips-handling-flat-files.aspx
Mpumelelo
- Edited by Mpumelelo S Wednesday, February 1, 2017 6:34 PM Clarity on the introduction.
DPM 2012 R2 CU11- DPM Console is working fine but DPM Reporting tab is crashes every time.
Console Error
Description:
AppName: mmc AppVer: 4.2.1205.0 ModName: mmc.exe
ModVer: 6.2.9200.16384 StackHash: 2ED00CEC
Problem signature:
Problem Event Name: DPMException
Application Name: mmc
Application Version: 4.2.1205.0
Module Name: mmc.exe
Module Version: 6.2.9200.16384
Exception Name: System.NullReferenceException
Exception Point: Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.RefreshListView
Other: 2ED00CEC
OS Version: 6.2.9200.2.0.0.272.7
Locale ID: 1033
Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=190175
If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt
_______________________________________________________________________________
Event id
The description for Event ID 999 from source MSDPM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
An unexpected error caused a failure for process 'mmc'. Restart the DPM process 'mmc'.
Problem Details:
<FatalServiceError><__System><ID>19</ID><Seq>0</Seq><TimeCreated>12/7/2016 8:05:51 AM</TimeCreated><Source>DpmThreadPool.cs</Source><Line>163</Line><HasError>True</HasError></__System><ExceptionType>NullReferenceException</ExceptionType><ExceptionMessage>Object reference not set to an instance of an object.</ExceptionMessage><ExceptionDetails>System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.RefreshListView()
at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.DisplayAppropriateListView()
at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.CheckAccountStatusAndUpdateUI()
at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.UpdateReportingUI()
at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.UpdateReportingPage()
at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.OnActivePageChanged(Object sender, ActivePageChangedEventArgs args)
at Microsoft.Internal.EnterpriseStorage.MmcContainer.PageController.OnActivePageChangedEventHandler.Invoke(Object sender, ActivePageChangedEventArgs e)
at Microsoft.Internal.EnterpriseStorage.MmcContainer.PageController.navigationTabs_SelectedIndexChanged(Object sender, NavigationPaneEventArgs e)
at Microsoft.Internal.EnterpriseStorage.MmcContainer.NavigationPaneControl.NavigationPane.ButtonClicked(NavigationButton sender)
at Microsoft.Internal.EnterpriseStorage.MmcContainer.NavigationPaneControl.NavigationButton.NavigationTab_MouseDown(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)</ExceptionDetails></FatalServiceError>
the message resource is present but the message is not found in the string/message table
Gurmeet Singh
- Edited by GURMEET SINGH 2020 Thursday, December 8, 2016 6:58 AM
- Changed type GURMEET SINGH 2020 Thursday, December 8, 2016 9:00 AM
No comments:
Post a Comment