Advertisement
Hello,<\/p>\n
I am new to Spiceworks. I previously used Lansweeper to scan our network and gather pc data. One of the features I need most is warranty information. I am not getting warranty information for any of our computers. When I click the link to rescan warranty information it says that no warranties are found.<\/p>\n
I found one article in the support section that walked you through forcing warranties to sync, but it did not work.<\/p>\n
I am Spiceworks version 7.5.00107.<\/p>\n
I looked at the database log files and found that there is an error connecting to Dell api. There is an “HTTPServerException: 404 Not Found” error. I have copied the what I think pertains to this issue from the log file data below.<\/p>\n
D[14:28:06.62 fe7430] [4;35;1mCategory Load (1.0ms)[0m [0mSELECT * FROM “categories” ORDER BY position ASC[0m Am I safe to assume that Dell is the problem and not Spiceworks?<\/p>\n Thank you, Hello,<\/p>\n I am new to Spiceworks. I previously used Lansweeper to scan our network and gather pc data. One of the features I need most is warranty information. I am not getting warranty information for any of our computers. When I click the link to rescan warranty information it says that no warranties are found.<\/p>\n I found one article in the support section that walked you through forcing warranties to sync, but it did not work.<\/p>\n I am Spiceworks version 7.5.00107.<\/p>\n I looked at the database log files and found that there is an error connecting to Dell api. There is an “HTTPServerException: 404 Not Found” error. I have copied the what I think pertains to this issue from the log file data below.<\/p>\n D[14:28:06.62 fe7430] [4;35;1mCategory Load (1.0ms)[0m [0mSELECT * FROM “categories” ORDER BY position ASC[0m Am I safe to assume that Dell is the problem and not Spiceworks?<\/p>\n Thank you,
\nD[14:28:06.62 fe7430] [4;36;1mAntiVirusProduct Load (0.0ms)[0m [0;1mSELECT * FROM “anti_virus_products” WHERE (“anti_virus_products”.computer_id = 12) ORDER BY vendor[0m
\nD[14:28:06.62 fe7430] expiring counter cache
\nD[14:28:06.62 fe7430] Cache delete matched: /^(TagCategory|DeviceCategory)-/
\nD[14:28:06.63 fe7430] [4;35;1mComputer Load (1.0ms)[0m [0mSELECT * FROM “devices” WHERE (“devices”.“id” = 12) AND ( (“devices”.“type” = ‘Computer’ ) ) [0m
\nD[14:28:06.63 fe7430] [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM “devices” WHERE (“devices”.“id” = 12) AND ( (“devices”.“type” = ‘Computer’ ) ) [0m
\nD[14:28:06.63 fe7430] [4;35;1mWarrantyCollection Load (0.0ms)[0m [0mSELECT * FROM “warranty_collections” WHERE (“warranty_collections”.device_id = 12) LIMIT 1[0m
\nD[14:28:06.63 fe7430] [4;36;1mAppStat Load (1.0ms)[0m [0;1mSELECT * FROM “app_stats” WHERE (“app_stats”.“key” = ‘dell_warranty_scan_total_num_devices’ AND “app_stats”.“user_id” IS NULL) LIMIT 1[0m
\nD[14:28:06.63 fe7430] [4;35;1mAppStat Update (0.0ms)[0m [0mUPDATE “app_stats” SET “value” = ‘6’ WHERE “id” = 772[0m
\nI[14:28:06.63 fe7430] WSN: Scanning Device Tags GGKQ8V1 for Warranty Scan [DELL]
\nD[14:28:06.63 fe7430] [4;36;1mAppStat Load (0.0ms)[0m [0;1mSELECT * FROM “app_stats” WHERE (“app_stats”.“key” = ‘dell_warranty_scan_attempt’ AND “app_stats”.“user_id” IS NULL) LIMIT 1[0m
\nD[14:28:06.63 fe7430] [4;35;1mAppStat Update (0.0ms)[0m [0mUPDATE “app_stats” SET “value” = ‘6’ WHERE “id” = 773[0m
\nI[14:28:06.63 fe7430] WSN: Dell XML URL - https://api.dell.com/support/assetinfo/v4/getassetwarranty/GGKQ8V1?apikey=e3b32000-ffcb-4033-9c34-b48d4774e41b<\/a>
\nD[14:28:06.63 fe7430] https_get: HTTPS connect to api.dell.com:443<\/a>
\nD[14:28:06.75 fe7430] https_get: GET /support/assetinfo/v4/getassetwarranty/GGKQ8V1?apikey=e3b32000-ffcb-4033-9c34-b48d4774e41b
\nE[14:28:06.77 fe7430] WSN: Exception caught. #<Net::HTTPServerException: 404 “Not Found”> C:/Program Files (x86)/Spiceworks/lib/ruby/2.1.0/net/http/response.rb:119:in `error!’
\nC:/Program Files (x86)/Spiceworks/pkg/gems/spiceworks_lib-7.5.00107/http_proxy.rb:182:in `https_get’
\n(eval):173:in `dell_api_content’
\n(eval):312:in `scrape_site’
\n(eval):288:in `block in scan_warranties’
\n(eval):283:in `each_slice’
\n(eval):283:in `scan_warranties’<\/p>\n
\nJoe Keating<\/p>","upvoteCount":2,"answerCount":7,"datePublished":"2021-06-23T19:13:45.000Z","author":{"@type":"Person","name":"joekeating","url":"https://community.spiceworks.com/u/joekeating"},"suggestedAnswer":[{"@type":"Answer","text":"
\nD[14:28:06.62 fe7430] [4;36;1mAntiVirusProduct Load (0.0ms)[0m [0;1mSELECT * FROM “anti_virus_products” WHERE (“anti_virus_products”.computer_id = 12) ORDER BY vendor[0m
\nD[14:28:06.62 fe7430] expiring counter cache
\nD[14:28:06.62 fe7430] Cache delete matched: /^(TagCategory|DeviceCategory)-/
\nD[14:28:06.63 fe7430] [4;35;1mComputer Load (1.0ms)[0m [0mSELECT * FROM “devices” WHERE (“devices”.“id” = 12) AND ( (“devices”.“type” = ‘Computer’ ) ) [0m
\nD[14:28:06.63 fe7430] [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM “devices” WHERE (“devices”.“id” = 12) AND ( (“devices”.“type” = ‘Computer’ ) ) [0m
\nD[14:28:06.63 fe7430] [4;35;1mWarrantyCollection Load (0.0ms)[0m [0mSELECT * FROM “warranty_collections” WHERE (“warranty_collections”.device_id = 12) LIMIT 1[0m
\nD[14:28:06.63 fe7430] [4;36;1mAppStat Load (1.0ms)[0m [0;1mSELECT * FROM “app_stats” WHERE (“app_stats”.“key” = ‘dell_warranty_scan_total_num_devices’ AND “app_stats”.“user_id” IS NULL) LIMIT 1[0m
\nD[14:28:06.63 fe7430] [4;35;1mAppStat Update (0.0ms)[0m [0mUPDATE “app_stats” SET “value” = ‘6’ WHERE “id” = 772[0m
\nI[14:28:06.63 fe7430] WSN: Scanning Device Tags GGKQ8V1 for Warranty Scan [DELL]
\nD[14:28:06.63 fe7430] [4;36;1mAppStat Load (0.0ms)[0m [0;1mSELECT * FROM “app_stats” WHERE (“app_stats”.“key” = ‘dell_warranty_scan_attempt’ AND “app_stats”.“user_id” IS NULL) LIMIT 1[0m
\nD[14:28:06.63 fe7430] [4;35;1mAppStat Update (0.0ms)[0m [0mUPDATE “app_stats” SET “value” = ‘6’ WHERE “id” = 773[0m
\nI[14:28:06.63 fe7430] WSN: Dell XML URL - https://api.dell.com/support/assetinfo/v4/getassetwarranty/GGKQ8V1?apikey=e3b32000-ffcb-4033-9c34-b48d4774e41b<\/a>
\nD[14:28:06.63 fe7430] https_get: HTTPS connect to api.dell.com:443<\/a>
\nD[14:28:06.75 fe7430] https_get: GET /support/assetinfo/v4/getassetwarranty/GGKQ8V1?apikey=e3b32000-ffcb-4033-9c34-b48d4774e41b
\nE[14:28:06.77 fe7430] WSN: Exception caught. #<Net::HTTPServerException: 404 “Not Found”> C:/Program Files (x86)/Spiceworks/lib/ruby/2.1.0/net/http/response.rb:119:in `error!’
\nC:/Program Files (x86)/Spiceworks/pkg/gems/spiceworks_lib-7.5.00107/http_proxy.rb:182:in `https_get’
\n(eval):173:in `dell_api_content’
\n(eval):312:in `scrape_site’
\n(eval):288:in `block in scan_warranties’
\n(eval):283:in `each_slice’
\n(eval):283:in `scan_warranties’<\/p>\n
\nJoe Keating<\/p>","upvoteCount":2,"datePublished":"2021-06-23T19:13:45.000Z","url":"https://community.spiceworks.com/t/new-install-of-spiceworks-not-pulling-warranty-data/803688/1","author":{"@type":"Person","name":"joekeating","url":"https://community.spiceworks.com/u/joekeating"}},{"@type":"Answer","text":"